| PLS-00201:error [message #126001] |
Thu, 30 June 2005 08:07  |
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  |
Frank Naude
Messages: 4579
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
