How can I transfer data from 12C to 11g?
How to Import Oracle 12C Dump into 11g Database
- What is the scenario: Exported the database using 12c expdp.
- What Command you used: impdp system/system directory=backup dumpfile=test12c.dmp logfile=test12.log schemas=test version=11.2.
- What Error message you get: ORA-39142 incompatible version.
- Solution:
What is data dump in Oracle?
The Data Pump export utility provides a mechanism for transferring data objects between Oracle databases. The utility is invoked with the following command: Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp You can control how Export runs by entering the ‘expdp’ command followed by various parameters.
How to transport a database in Oracle 11 g?
To perform a full transportable export on an Oracle Database 11 g Release 2 (11.2.0.3) or later Oracle Database 11 g database, use the VERSION parameter, as shown in the following example: Full transportable import is supported only for Oracle Database 12 c and later databases.
How to create an export dump file for a database?
The FULL parameter specifies that the entire database is being exported. The DUMPFILE parameter specifies the name of the structural information export dump file to be created, expdat.dmp. The DIRECTORY parameter specifies the directory object that points to the operating system or Oracle Automatic Storage Management location of the dump file.
What is the version of Oracle Database 11 g?
Ensure that the following parameters are set to the specified values: If the source database is an Oracle Database 11 g Release 2 (11.2.0.3) or later Oracle Database 11 g database, then you must set the VERSION parameter to 12 or higher.
What is the directory parameter in export dump file?
The DIRECTORY parameter specifies the directory object that points to the operating system or Oracle Automatic Storage Management location of the dump file. You must create the DIRECTORY object before invoking Data Pump, and you must grant the READ and WRITE object privileges on the directory to the user running the Export utility.