Fulltext results:

Oracle: List Accounts with Objects

8 Hits, Last modified: 13 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: 13 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

3 Hits, Last modified: 13 years ago

e PFile ===== To export the SPFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFil... 2]] Example: Set flash recovery area to 8GB. The usage of ''SCOPE=BOTH'' changes the init param in me

Oracle: SQLplus Scripting

3 Hits, Last modified: 13 years ago

====== Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, enter the following: <c... SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF </code> {{tag>oracle scripting sqlplus}}