Fulltext results:

Oracle: List Accounts with Objects

7 Hits, Last modified: 12 years ago

counts with Objects ====== To list all accounts (users) the objects (like tables), you can query them... unts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_US

Oracle: EXP

4 Hits, Last modified: 12 years ago

ount ===== Enter the account name insteand of ''{user}''. <code 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: 12 years ago

2]] Example: Set flash recovery area to 8GB. The usage of ''SCOPE=BOTH'' changes the init param in me