Fulltext results:

Oracle: SPFile and PFiles

10 Hits, Last modified: 12 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are ... FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora''. ===== Import

Oracle

6 Hits, Last modified: 9 years ago

====== Oracle ====== ===== Pages ===== {{indexmenu>.}} ===== Bookmarks ===== * [[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 Doc

Oracle Errors

4 Hits, Last modified: 12 years ago

====== Oracle Errors ====== ===== ORA-00257: archiver error. Connect internal only, until freed. ===== ... area]]. * **Documentation**: [[http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/e0.htm#sthref181|10.2]] [[http://download.oracle.com/docs/cd/E11882_01/server.112/e10880/e0.htm#sthref197|11.2]] {{tag>database documentation error oracle reference}}

Oracle: List Accounts with Objects

2 Hits, Last modified: 12 years ago

====== Oracle: List Accounts with Objects ====== To list all accounts (users) the objects (like tables), ... DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}}

Oracle: Resize Instance

2 Hits, Last modified: 12 years ago

====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB.... he instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}

Oracle: EXP

2 Hits, Last modified: 12 years ago

====== Oracle: EXP ====== ===== Export all Objects from an Account ===== Enter the account name insteand... ode bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}

Oracle: SQLplus Scripting

2 Hits, Last modified: 12 years ago

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

Oracle: Recovery Manager

2 Hits, Last modified: 12 years ago

====== Oracle: Recovery Manager ====== ===== Start Recovery Manager ===== <code bash> rman target / </co... G ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin database dba oracle rman sysadmin}}