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