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

Card Puncher Data Processing

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.

Data Pump Sqldeveloper

Support

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.

Reference





Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
Oracle Database - ASM (Automatic Storage Management)

Starting with Oracle Database 10g (10.1.0.3 or later), Automatic Storage Management is a high-performance storage management solution. For Oracle Database files, it simplifies the management of a dynamic...
Card Puncher Data Processing
Oracle Database - Data Load

Data loading in a Oracle Database environment. In the Oracle Database, you can load data in the following elements: Table, View , Materialized View, External Table Oracle Version Utility...
Data Pump Sqldeveloper
Oracle Database - Data Pump Import (impdp)

The import utility of data pump In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory...
Card Puncher Data Processing
Oracle Database - Import (imp)

Import utility that can work on a remote computer (not on the server as ). See The Export utility always exports user data, including Unicode data, in the character sets of the Export server....
Card Puncher Data Processing
Oracle Database - Physical Database Structures (Files)

Oracle Database files include: data files, temporary files, control files, the server parameter file, the password file. redo log files, Archived Redo Log Files Parameter Files Alert...
Ttbulkcp Sql Developer
Timesten - ttBulkCp

ttBulkCp is an utility to import and export data from a Timesten database Attribute lines are used for setting file attributes, which control the formatting of the datafile. Attribute lines...



Share this page:
Follow us:
Task Runner