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_USER

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}}