Oracle Database - Data Pump - (Export|Import) Utilities

> Database > Oracle Database

1 - About

Oracle Data Pump works with the file system of the database whereas Export and Import utilities works with the client file system.

Since Oracle Database 10g, Oracle Data Pump enables movement of data and metadata from one database to another with the following tools:

Data Pump Export unload data and metadata into a set of operating system files called a dump file set. The dump file set exported can only be imported only by the Data Pump Import utility.

Advertising

3 - Support

3.1 - PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared

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

You can get this error if the database is not open.

4 - Reference