Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Database Question
David,
We are using 8.1.7.3. Here are my results from running those scripts. I still must be missing something.
SVRMGR> @/u01/app/oracle/product/8.1.7.3/rdbms/admin/dbmsotpt.sql
Statement processed. Statement processed. Statement processed.
SVRMGR> ALTER DATABASE ARCHIVELOG;
Statement processed.
ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_OUTPUT.GET_LINES' must be declared ORA-06550: line 1, column 7:
ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_OUTPUT.GET_LINES' must be declared ORA-06550: line 1, column 7:
I have run the following scripts during the database creation:
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catio.sql
@$ORACLE_HOME/rdbms/admin/dbmspool.sql
@$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
@$ORACLE_HOME/rdbms/admin/prvtotpt.plb
Received on Wed Apr 06 2005 - 12:22:48 CDT