All In One Datapump Parameters Up To Oracle 18c (A-Z)

Description:-

In this article we are covering all the datapump parameters upto 18c database

Oracle 10g Release 1

ATTACH https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-attach-parameter/

CONTENT https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-content-parameter-2/

DIRECTORY https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-directory-parameter/ 
    
DUMPFILE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-dumpfile-parameter/          
        
ESTIMATE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-estimate-parameter/

ESTIMATE_ONLY  http://www.oracledbwr.com/18c-datapump/oracle-18c-datap…e_only-parameter/


EXCLUDE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-exclude-parameter/


FLASHBACK_SCN https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-flashback_scn-parameter/  
 
FLASHBACK_TIME https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-flashback_time-parameter/  
 
FULL https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-database-level/

HELP https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-help-parameter/

INCLUDE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-include-parameter/ 
JOB_NAME https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-job_name-parameter/

NETWORK_LINK https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-network-link/
NOLOGFILE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-nologfile-parameter/

PARALLEL https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-parallel-parameter/

PARFILE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-parfile-parameter/

QUERY https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-query-parameter/

REMAP_DATAFILE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_datafile-parameter/

REMAP_SCHEMA https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_schema-parameter/ 

REMAP_TABLESPACE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_tablespace-parameter/         
            
REUSE_DUMPFILES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-reuse_dumpfiles-parameter/

SCHEMAS https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-schema-level/

SKIP_UNUSABLE_INDEXES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-skip_unusable_indexes-parameter/

SQLFILE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-sqlfile-parameter/

STATUS https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-status-parameter/

 
TABLE_EXISTS_ACTION  https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-table_exists_action-parameter/


TABLES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-table-level/

TABLESPACES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-tablespace-level/

TRANSPORT_DATAFILES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-transport_datafiles-parameter/

TRANSPORT_TABLESPACES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-transport_tablespaces-parameter/

VERSION https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-version-parameter/

CONTINUE_CLIENT https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-continue_client-parameter/

EXIT_CLIENT https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-exit_client-parameter/

HELP https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-help-parameter/

KILL_JOB https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-kill_job-parameter/

PARALLEL https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-parallel-parameter/

START_JOB https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-start_job-parameter/

STATUS https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-status-parameter/

STOP_JOB https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-stop_job-parameter/

ADD_FILE https://www.oracledbwr.com/18c-database/oracle-18c-datapump-add_file-parameter/

REMAP_SCHEMA https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_schema-parameter/

Oracle 10g Release 2

ENCRYPTION_PASSWORD https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-encryption_password-parameter/


FILESIZE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-filesize-parameter/

SAMPLE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-sample-parameter/

COMPRESSION https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-compression-parameter/

Oracle 11g Release 1


PARTITION_OPTIONS https://www.oracledbwr.com/18c-datapump/oracle-18c-datap…ptions-parameter/


REMAP_DATA http://www.oracledbwr.com/18c-datapump/oracle-18c-datap…p_data-parameter/


REMAP_TABLE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_table-parameter/

ENCRYPTION https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-encryption-parameter-2/

ENCRYPTION_ALGORITHM https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-encryption_algorithm-parameter/

ENCRYPTION_MODE https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-encryption_mode-parameter/

Oracle 11g Release 2

Source_edition

https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-source_edition-parameter/

Target_edition

https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-target_edition-parameter/
Oracle 12c Release 1

VIEWS_AS_TABLES https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-views_as_tables-parameter/

METRICS https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-metrics-parameter/

MASTER_ONLY http://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-master_only-parameter/


KEEP_MASTER https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-keep_master-parameter/

ENCRYPTION_PWD_PROMPT https://www.oracledbwr.com/uncategorized/oracle-18c-datapump-encryption_pwd_prompt-parameter/


DISABLE_ARCHIVE_LOGGING https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-disable_archive_logging-parameter/
LOGTIME https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-logfile-parameter/


Oracle 12c Release 2

REMAP_DIRECTORY https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-remap_directory-parameter/

TRANSPORT_DATAFILES https://www.oracledbwr.com/18c-datapump/oracle-18c-datap…afiles-parameter/

LOGTIME https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-logtime-parameter/

Oracle 18c Release 1

DATABASE LINK https://www.oracledbwr.com/18c-datapump/oracle-18c-datapump-database-link/

 

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