Fulltext results:

Oracle: Recovery Manager

4 Hits, Last modified: 12 years ago

ast 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove arch... un: <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script could be (deleting all logs except the last three ... et / << __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{

Oracle: SQLplus Scripting

3 Hits, Last modified: 12 years ago

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

Oracle

2 Hits, Last modified: 9 years ago

===== Bookmarks ===== * [[http://www.oracle.com/pls/db102/homepage|Oracle Database Online Documentat... 0g Release 2 (10.2)]] * [[http://www.oracle.com/pls/db112/homepage|Oracle Database Online Documentat

Oracle: SPFile and PFiles

2 Hits, Last modified: 12 years ago

PFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> ... 2/e10820/initparams063.htm#REFRN10235|11.2]] Example: Set flash recovery area to 8GB. The usage of ''

Oracle: Resize Instance

1 Hits, Last modified: 12 years ago

===== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2

Oracle: List Accounts with Objects

1 Hits, Last modified: 12 years ago

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