Fulltext results:

Oracle: List Accounts with Objects

1 Hits, Last modified: 13 years ago

DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}}

Oracle: Resize Instance

1 Hits, Last modified: 13 years ago

e instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}

Oracle: EXP

1 Hits, Last modified: 13 years ago

de bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}

Oracle: SPFile and PFiles

1 Hits, Last modified: 13 years ago

ode sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE=BOTH SID='*'; </code> {{tag>admin oracle}}

Oracle: Recovery Manager

1 Hits, Last modified: 13 years ago

ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin database dba oracle rman sysadmin}}