Ask the Expert

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, 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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: