Fulltext results:

Oracle: Recovery Manager

15 Hits, Last modified: 13 years ago

er ====== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== Delete Archive Logs ===== Delete all archive logs but keep the last 45 days: <code sql> DELETE ARCHIVE

Oracle: SPFile and PFiles

11 Hits, Last modified: 13 years ago

a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}... ath to the PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='$... CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> If your PFile is located at ''/db/oracle/config

Oracle: List Accounts with Objects

9 Hits, Last modified: 13 years ago

jects (like tables), you can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to list all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USER

Oracle: Resize Instance

6 Hits, Last modified: 13 years ago

rst, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G S... LTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; </code> Then, (optionally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code s

Oracle: SQLplus Scripting

3 Hits, Last modified: 13 years ago

ng ====== To show only data in SQLplus and no header or other stuff, enter the following: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGES... SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF </code> {{tag>oracle scripting sqlplus}}

Oracle: EXP

2 Hits, Last modified: 13 years ago

nter the account name insteand of ''{user}''. <code bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}

andunix Infos

1 Hits, Last modified: 12 years ago

===== andunix Infos ===== {{indexmenu>info:#1 .:#1}} ===== Tags ===== ~~TAGCLOUD:50~~

Oracle

1 Hits, Last modified: 11 years ago

====== Oracle ====== ===== Pages ===== {{indexmenu>.}} ===== Bookmarks ===== * [[http://www.oracle.