Home » RDBMS Server » Server Administration » PLS-00201:error
PLS-00201:error [message #126001] Thu, 30 June 2005 08:07 Go to next message
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
. 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: 4518
Registered: April 1998
Senior Member
See Metalink Note 304449.1: Database Export fails with PLS-00201 identifier DMSYS.DBMS_MODEL_EXP must be declared:


If DMSYS has already been dropped

Start SQLPLUS and connect with user SYS as SYSDBA
SQL> exit;
proceed with export jobs

If dmsys schema objects have been accidentally removed

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. or
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.

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

Previous Topic: Database fragmentation and shrinking
Next Topic: ORA-04067 error when exporting
Goto Forum:

Current Time: Mon Aug 21 05:25:25 CDT 2017

Total time taken to generate the page: 0.11408 seconds