Posted on April 24, 2010 by pandazen
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;
Filed under: Oracle | Tagged: controlfile | Leave a comment »
Posted on April 23, 2010 by pandazen
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;
Filed under: Oracle, Uncategorized | Tagged: tablespace | Leave a comment »
Posted on April 14, 2010 by pandazen
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
Filed under: Oracle | Tagged: oracle error code | Leave a comment »