Q

Getting PLS-00201 error while exporting schema

I had a problem while exporting a schema and followed your advice regarding this error: "PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared." The package did not exist so I ran the script "@?/rdbms/admin/prvtxdb.plb" you recommended. There are errors.

I had a problem while exporting a schema and followed your advice regarding this error: "PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared." The package did not exist so I ran the script "@?/rdbms/admin/prvtxdb.plb" you recommended. There are errors, including the following:
Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY XDB.DBMS_XDBUTIL_INT:

LINE/COL ERROR 
-------- ----------------------------------------------------------------- 
61/7     PL/SQL: Statement ignored 
61/17    PLS-00306: wrong number or types of arguments in call to
         'IS_HIERARCHY_ENABLED_INTERNAL' 
                                                                               
74/7     PL/SQL: Statement ignored
74/29    PLS-00302: component 'GENERATE_TRGNM' must be declared
108/9    PL/SQL: Statement ignored 
108/37   PLS-00302: component 'TRUNCATE_NAME' must be declared
123/7    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared
123/7    PL/SQL: Statement ignored 
135/9    PL/SQL: Statement ignored     

LINE/COL ERROR                 
-------- ----------------------------------------------------------------- 
135/37   PLS-00302: component 'TRUNCATE_NAME' must be declared
153/9    PL/SQL: Statement ignored
153/33   PLS-00302: component 'TRUNCATE_NAME' must be declared
168/7    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared
168/7    PL/SQL: Statement ignored 
181/9    PL/SQL: Statement ignored
181/33   PLS-00302: component 'TRUNCATE_NAME' must be declared

Synonym created.


Grant succeeded.

Errors for PACKAGE BODY XDB.DBMS_XDBUTIL_INT:

LINE/COL ERROR 
-------- ----------------------------------------------------------------- 
61/7     PL/SQL: Statement ignored
61/17    PLS-00306: wrong number or types of arguments in call to 
         'IS_HIERARCHY_ENABLED_INTERNAL' 
                                                                               
74/7     PL/SQL: Statement ignored
74/29    PLS-00302: component 'GENERATE_TRGNM' must be declared
108/9    PL/SQL: Statement ignored
108/37   PLS-00302: component 'TRUNCATE_NAME' must be declared
123/7    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared
123/7    PL/SQL: Statement ignored                                             
135/9    PL/SQL: Statement ignored
Did you run the supplied script as the SYS user? Running the script as SYSTEM can have errors similar to the above.

If you ran this as SYS, then I recommend at this point that you open a Service Request with Oracle Support.

This was first published in July 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close