Fulltext results:

Oracle: SPFile and PFiles

6 Hits, Last modified: 13 years ago

</code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora''. ===== Import PFile ===... MMEDIATE; </code> If your PFile is located at ''/db/oracle/config/pfiles/initweb.ora'', the the secon... ine would be: <code sql> STARTUP NOMOUNT PFILE='/db/oracle/config/pfiles/initweb.ora' </code> ===== ... ameters ===== ==== Flash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZE === The parameter ''DB_R

Oracle: List Accounts with Objects

3 Hits, Last modified: 13 years ago

them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to ... ER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}

Oracle

2 Hits, Last modified: 10 years ago

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

Oracle: Recovery Manager

1 Hits, Last modified: 13 years ago

L COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin database dba oracle rman sysadmin}}

Oracle: EXP

1 Hits, Last modified: 13 years ago

of ''{user}''. <code bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {

Oracle: SQLplus Scripting

1 Hits, Last modified: 13 years ago

ET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP