Oracle Control File

To alter control file

– login via sqlplus as sysdba

– shutdown immediate;

– alter SYSTEM set control_files=’E:\ORACTL\CONTROL01.CTL’, ‘F:\ORACTL\CONTROL02.CTL’, ‘G:\ORACTL\CONTROL03.CTL’, ‘H:\ORACTL\CONTROL04.CTL’ SCOPE=SPFILE;

-shutdown immediate;

-startup;

Advertisements

Oracle Default Tablespace

To find the default permanent tablespace name for the database is
SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ‘DEFAULT_PERMANENT_TABLESPACE’;

To find the default temporary tablespace name for the database is
SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ‘DEFAULT_TEMP_TABLESPACE’;

To set default tablespace to be users
ALTER DATABASE DEFAULT TABLESPACE ts_user;

To set default tablespace to be users
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tmp_group;

ORA-06550 – DBMS_SHARED_POOL

when i run DBMS_SHARED_POOL.KEEP, i got this error message

ORA-06550: line 2, column 4:
PLS-00201: identifier ‘DBMS_SHARED_POOL.KEEP’ must be declared

after i search net, the solution is to run the script dbmspool.sql located in ORACLE_HOME\RDBMS\admin as sysdba