##########################################
##	DATA PUMP EXPORT (EXPDP)
##########################################
expdp C##DBA@PDB PARFILE=parfile.par

COMPRESSION=[ NONE| DATA_ONLY | METADATA_ONLY | ALL ]
COMPRESSION_ALGORITHM= [ BASIC | LOW | MEDIUM | HIGH ]
CONTENT=[ ALL | DATA_ONLY | METADATA_ONLY ]
DUMPFILE=DumpFileName_%U__%D-%M-%Y.dmp
ENCRYPTION=[ ALL | DATA_ONLY | ENCRYPTED_COLUMNS_ONLY | METADATA_ONLY | NONE ]
ENCRYPTION_ALGORITHM=[ AES128 | AES192 | AES256 ]
ENCRYPTION_MODE=[ DUAL | PASSWORD | TRANSPARENT ]
ENCRYPTION_PASSWORD=password
ENCRYPTION_PWD_PROMPT=[ YES | NO ]
ESTIMATE=[ BLOCKS | STATISTICS ]
ESTIMATE_ONLY=[ YES | NO ]
EXCLUDE=object_type [ TABLE,VIEW,FUNCTION,PROCEDURE,SEQUENCE,SYNONYM,PACKAGE,PACKAGE BODY,TRIGGER,INDEX,MATERIALIZED VIEW ]
INCLUDE=object_type [ TABLE,VIEW,FUNCTION,PROCEDURE,SEQUENCE,SYNONYM,PACKAGE,PACKAGE BODY,TRIGGER,INDEX,MATERIALIZED VIEW ]
FILESIZE=integer[ B | KB | MB | GB | TB ]
FULL=[ NO | YES ]
HELP=[ NO | YES ]
JOB_NAME=JOBNAME_STRING
KEEP_MASTER=[ NO | YES ]
LOGFILE=[ directory_object: ]file_name
NOLOGFILE=[ NO | YES ]
LOGTIME=[ NONE | STATUS | LOGFILE | ALL ]
METRICS=[ NO | YES ]
PARALLEL=integer ##COMMAND LINUX:         nproc           (or)         grep -c ^processor /proc/cpuinfo
QUERY=[ schema. ][ table_name: ] query_clause
REUSE_DUMPFILES=[ NO | YES ]
SAMPLE=70  #   "HR"."EMPLOYEES":50 
SCHEMAS=schema_name [ , ...hr,sh,oe ]
STATUS=0 
TABLES=[ schema_name. ]table_name[ :partition_name ] [ , ...employees,jobs,departments ]
TABLESPACES=tablespace_name [ , ...tbs_4, tbs_5, tbs_6 ]
TRANSPORT_FULL_CHECK=[ NO | YES ]
TRANSPORT_TABLESPACES=tablespace_name [ , ... ]
TRANSPORTABLE=[ NEVER |ALWAYS ]
VERSION=[ COMPATIBLE | LATEST | version_string ]

##########################################
##	DATA PUMP IMPORT (IMPDP)
##########################################
impdp C##DBA@PDB PARFILE=parfile.par

CONTENT=[ ALL | DATA_ONLY | METADATA_ONLY ]
DIRECTORY=directory_object
DUMPFILE=[ directory_object: ]file_name [ , ... ] %U %l, %L
ENCRYPTION_PASSWORD=password
ENCRYPTION_PWD_PROMPT=[ NO | YES ]
ESTIMATE=[ BLOCKS | STATISTICS ]
EXCLUDE=object_type [ TABLE,VIEW,FUNCTION,PROCEDURE,SEQUENCE,SYNONYM,PACKAGE,PACKAGE BODY,TRIGGER,INDEX,MATERIALIZED VIEW ]
INCLUDE=object_type [ TABLE,VIEW,FUNCTION,PROCEDURE,SEQUENCE,SYNONYM,PACKAGE,PACKAGE BODY,TRIGGER,INDEX,MATERIALIZED VIEW ]
FULL=YES
HELP=[ NO | YES ]
JOB_NAME=JOBNAME_STRING
KEEP_MASTER=[ NO | YES ]
LOGFILE=[ directory_object: ]file_name
NOLOGFILE=[ NO | YES ]
LOGTIME=[ NONE | STATUS | LOGFILE | ALL ]
MASTER_ONLY=[ NO | YES ]
METRICS=[ NO | YES ]
PARALLEL=integer ##COMMAND LINUX:         nproc           (or)         grep -c ^processor /proc/cpuinfo
PARALLEL_THRESHOLD=size-in-bytes
QUERY=[ [ schema_name. ]table_name: ]query_clause
REMAP_DATA=[ schema. ]tablename.column_name:[ schema. ]pkg.function
REMAP_DATAFILE=source_datafile:target_datafile
REMAP_DIRECTORY=source_directory_string:target_directory_string
REMAP_SCHEMA=source_schema:target_schema
REMAP_TABLE=[ schema. ]old_tablename[ :partition ]:new_tablename
REMAP_TABLESPACE=source_tablespace:target_tablespace
SCHEMAS=schema_name [ , ...hr,sh,oe ]
SERVICE_NAME=name
SKIP_UNUSABLE_INDEXES=[ YES | NO ]
SOURCE_EDITION=edition_name
SQLFILE=[ directory_object: ]file_name
STATUS[ =integer ]
STREAMS_CONFIGURATION=[ YES | NO ]
TABLE_EXISTS_ACTION=[ SKIP | APPEND | TRUNCATE | REPLACE ]
REUSE_DATAFILES=[ YES | NO ]
TABLES=[ schema_name. ]table_name[ :partition_name ]
TABLESPACES=tablespace_name [ , ... ]
TARGET_EDITION=name
TRANSFORM=transform_name:value[ :object_type ]
TRANSPORT_FULL_CHECK=[ NO | YES ]
TRANSPORT_TABLESPACES=tablespace_name [ , ... ]
TRANSPORTABLE=[ ALWAYS|NEVER|KEEP_READ_ONLY|NO_BITMAP_REBUILD ]
VERSION=[ COMPATIBLE | LATEST | version_string ]
VIEWS_AS_TABLES=[ schema_name. ]view_name[ :table_name ], ...

##########################################
# Command Used		# Activity
##########################################		
CONTINUE_CLIENT		# Exit interactive-command mode.
EXIT_CLIENT			# Stop the import client session, but leave the current job running.
HELP				# Display a summary of available commands.
KILL_JOB			# Detach all currently attached client sessions and terminate the current job.
PARALLEL			# Increase or decrease the number of active worker processes for the current job.  
START_JOB			# Restart a stopped job to which you are attached.
STATUS				# Display detailed status for the current job.
STOP_JOB			# Stop the current job.	


##########################################
##	Directory Configuration
##########################################
CREATE OR REPLACE DIRECTORY DIR_DUMP AS '/caminho/para/dump';
GRANT READ, WRITE ON DIRECTORY DIR_DUMP TO user;