Fulltext results:

Oracle: List Accounts with Objects

3 Hits, Last modified: 12 years ago

ode sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to list all accoun... ith: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}

Oracle: Recovery Manager

1 Hits, Last modified: 12 years ago

'SYSDATE -45'; </code> To remove archive logs older than 3 days without prompting, e.g. via cron, aft

Oracle: SQLplus Scripting

1 Hits, Last modified: 12 years ago

ng ====== To show only data in SQLplus and no header or other stuff, enter the following: <code sql>