SYMPOTMS
When trying to run datapump impdp into a PDB, the following errors occurred:
UDI-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
CAUSES
The PDB database is not open.
SQL> show con_name CON_NAME ------------------------------ pdb1 SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED
RESOLUTION
Open the PDB database.
SQL> show con_name CON_NAME ------------------------------ pdb1 SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED SQL> alter pluggable database open; Pluggable database altered. SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE
Make DBA Life Easy 