Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Database Question

Re: Alter Database Question

From: <amerar_at_iwc.net>
Date: 6 Apr 2005 10:22:48 -0700
Message-ID: <1112808168.244353.9000@l41g2000cwc.googlegroups.com>

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> @/u01/app/oracle/product/8.1.7.3/rdbms/admin/prvtotpt.plb 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:

PL/SQL: Statement ignored
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.GET_LINES' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US