Home » RDBMS Server » Server Administration » PLS-00201:error
PLS-00201:error [message #126001] Thu, 30 June 2005 08:07 Go to next message
snagra
Messages: 23
Registered: March 2005
Junior Member


I'm getting the following when exporting. How would have this been caused and can anyone advise me what I need to do and how to do it to get around this please. I'm not sure if the the three errors are related. ie EXP-00008, ORA-6550 and PLS-00201


About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.sc
hema_info_exp
. exporting foreign function library names for user FLINKCOR
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user FLINKCOR

Re: PLS-00201:error [message #126139 is a reply to message #126001] Fri, 01 July 2005 03:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See Metalink Note 304449.1: Database Export fails with PLS-00201 identifier DMSYS.DBMS_MODEL_EXP must be declared:

Quote:

If DMSYS has already been dropped

Start SQLPLUS and connect with user SYS as SYSDBA
SQL> DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';
SQL> exit;
proceed with export jobs

If dmsys schema objects have been accidentally removed

set ORACLE_HOME and ORACLE_SID
Start SQLPLUS and connect with user SYS as SYSDBA
SQL> run $ORACLE_HOME/dm/admin/dminst.sql SYSAUX TEMP $ORACLE_HOME/dm/admin/
SQL> run $ORACLE_HOME/dm/admin/odmpatch.sql (if the database is at 10g patch level, e.g. 10.1.0.3 or 10.1.0.4)
SQL> run $ORACLE_HOME/rdbms/admin/utlrp.sql
Ensure 'Oracle Data Mining' is at Valid status in dba_registry
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME='Oracle Data Mining';
proceed with export jobs


Best regards.

Frank
icon14.gif  Re: PLS-00201:error [message #311697 is a reply to message #126139] Sat, 05 April 2008 16:21 Go to previous message
mmpdba
Messages: 2
Registered: April 2008
Location: ATHENS, GA
Junior Member
I had a same situation and your solution worked perfectly for me.

Thanks,
mmpdba
Previous Topic: How to mount this database?
Next Topic: Oracle Express - Cannot connect to the service
Goto Forum:
  


Current Time: Mon Dec 05 10:44:19 CST 2016

Total time taken to generate the page: 0.18278 seconds