<<Back to Oracle DATAPUMP Main Page
How to Export Database from 12c for 11g Version
Using EXPDP VERSION Parameter
Syntax and DescriptionVERSION=[COMPATIBLE | LATEST | version_string]
Specifies the version of database objects to be exported. Only database objects and
attributes that are compatible with the specified release will be exported. This can be
used to create a dump file set that is compatible with a previous release of Oracle
Database.
• COMPATIBLE - This is the default value. The version of the metadata corresponds to the database compatibility level as specified on the COMPATIBLE initialization parameter. Database compatibility must be set to 9.2 or later.
• LATEST - The version of the metadata and resulting SQL DDL corresponds to the database release regardless of its compatibility level.
• version_string - A specific database release (for example, 11.2.0). In Oracle Database 11g, this value cannot be lower than 9.2.
$ cat exp.par
DIRECTORY=EXP
DUMPFILE=EXP.DMP
LOGFILE=EXP.LOG
FULL=Y
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP
VERSION=11.2.0.4
$ expdp test@PDB01 parfile=exp.par
Export: Release 12.2.0.1.0 - Production on Wed Nov 28 13:33:18 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Warning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers.
Starting "TEST"."SYS_EXPORT_FULL_01": test/********@PDB01 parfile=exp.par
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "TEST"."EXP_EDITION_TEST" 5.656 KB 14 rows
. . exported "TEST"."EMP" 5.539 KB 5 rows
. . exported "TEST"."EMP1" 5.484 KB 1 rows
. . exported "TEST"."TEST" 5.484 KB 1 rows
. . exported "TEST"."EMP_EDITION2" 5.492 KB 1 rows
. . exported "TEST_EXP"."TEST" 5.078 KB 3 rows
. . exported "TEST"."ENC_TEST1" 6.375 KB 0 rows
. . exported "TEST"."ENC_TEST2" 6.375 KB 0 rows
. . exported "TEST"."ENC_TEST3" 6.796 KB 0 rows
. . exported "TEST"."ENC_TEST4" 6.375 KB 0 rows
Master table "TEST"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TEST.SYS_EXPORT_FULL_01 is:
/u01/dbatst1/stage/EXP.DMP
Job "TEST"."SYS_EXPORT_FULL_01" successfully completed at Wed Nov 28 13:35:02 2018 elapsed 0 00:01:41
Using VERSION Parameter during Import: EXPDP
This parameter can be used to load a target system whose Oracle database is at anearlier compatibility release than that of the source system
Default: You should rarely have to specify the VERSION parameter on an import
operation. Data Pump uses whichever of the following is earlier:
• the version associated with the dump file, or source database in the case of network imports
• the version specified by the COMPATIBLE initialization parameter on the target database
Syntax and DescriptionVERSION=[COMPATIBLE | LATEST | version_string]
Comments
Post a Comment