UDE-06550: operation generated ORACLE error 6550-ORA-06550: line 1, column 100:-PLS-00201: identifier ‘SYS.DBMS_DATAPUMP’ must be declared

Cause:

Expdp fails with below error.

[oracle@orcl19x ~]$ expdp \'/ as sysdba\' directory=exp dumpfile=append.dmp logfile=append.log tables=test.regions_bkp

Export: Release 12.1.0.2.0 - Production on Fri Aug 13 14:08:13 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

UDE-06550: operation generated ORACLE error 6550
ORA-06550: line 1, column 100:
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 100:
PL/SQL: Statement ignored
ORA-06550: line 1, column 202:
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 202:
PL/SQL: Statement ignored

Workaround:

Check the database current status. It is in mount mode which throw this error to not access the database. SYS.DBMS_DATAPUMP procedure cannot be accessed due to inaccessible database.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

Open the database

SQL> alter database open;

Database altered.

Try export after database open

[oracle@orcl19x ~]$ expdp \'/ as sysdba\' directory=exp dumpfile=append.dmp logfile=append.log tables=test.regions_bkp

Export: Release 12.1.0.2.0 - Production on Fri Aug 13 14:17:46 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s