Fulltext results:

Oracle: SPFile and PFiles

13 Hits, Last modified: 13 years ago

"PFiles", which are regular text files. ===== Create PFile ===== To export the SPFiles to a PFile, j... st enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora''. ==... and the write the SPFile. You have to enter the path to the PFile instead of ${PATH_TO_PFILE}. <code

Oracle: Resize Instance

4 Hits, Last modified: 13 years ago

|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_t... lly) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}

Oracle: Recovery Manager

4 Hits, Last modified: 13 years ago

sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive logs older than... ETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script could be (deletin... ETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin database dba oracle rman sysadmin}}

Oracle

4 Hits, Last modified: 10 years ago

[http://www.oracle.com/pls/db102/homepage|Oracle Database Online Documentation 10g Release 2 (10.2)]] * [[http://www.oracle.com/pls/db112/homepage|Oracle Database Online Documentation 11g Release 2 (11.2)]] {{tag>oracle topic}}

Oracle Errors

3 Hits, Last modified: 13 years ago

|Enlarge the flash recovery area]]. * **Documentation**: [[http://download.oracle.com/docs/cd/B19306... 82_01/server.112/e10880/e0.htm#sthref197|11.2]] {{tag>database documentation error oracle reference}}

Oracle: SQLplus Scripting

1 Hits, Last modified: 13 years ago

= Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, enter t