Oracle 18c Datapump-TARGET_EDITION Parameter

• TARGET_EDITION parameter used in import datapump process.
•  You should remove the objects from the target edition before importing the dump.Importing the dumpfile / views to ORA$BASE edition.
• Drop the target edition present under HARI user and import TARGET_ EDITION.

SQL> SELECT SYS_CONTEXT('userenv', 'current_edition_name') FROM DUAL;

SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
----------------------------------------------
ORA$BASE

SQL> conn hari/oracle;
Connected.

SQL> ALTER SESSION SET EDITION =ORA$BASE;

Session altered.

SQL> drop view ed_emp_view_ORABASE;

View dropped.

Import  the dumpfile / views to ORA$BASE edition.

[oracle@18c empdata]$ impdp dumpfile=edition.dmp directory=TEST_DIR target_edition=ORA\$BASE

Import: Release 18.0.0.0.0 - Production on Sat Aug 25 02:38:44 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Username: system
Password:

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** dumpfile=edition.dmp directory=TEST_DIR target_edition=ORA$BASE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Sat Aug 25 02:38:51 2018 elapsed 0 00:00:03

After the import you can verify the import after setting corresponding edition.

SQL> conn hari/oracle;
Connected.
SQL> ALTER SESSION SET EDITION =ORA$BASE;

Session altered.

SQL> SELECT SYS_CONTEXT('userenv', 'current_edition_name') FROM DUAL;

SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
---------------------------------------------
ORA$BASE

SQL> desc ed_emp_view_ORABASE;

Name  Null?  Type
---- ----- ------
ID         NUMBER
SAL        NUMBER

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba