![]() ![]() ![]() The directory objects must be created before running expdb.įull export: CREATE OR REPLACE DIRECTORY export_dir AS '/u01/app/oracle/oradata/' The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. ![]() The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set can be imported only by the Data Pump Import utility impdb. STOP_JOB=IMMEDIATE performs an immediate shutdown of theĮxpdp is a server side utility used to unload database data into a set of OS files called a 'dump file set'. STOP_JOB Orderly shutdown of job execution and exits the client. The default (0) will show new status when available. STATUS Frequency (secs) job status is to be monitored where REUSE_DUMPFILES Overwrite destination dump file if it exists ( N) PARALLEL Change the number of active workers for current job. Job will be re-started if idle.ĮXIT_CLIENT Quit client session and leave job running.įILESIZE Default filesize (bytes) for subsequent ADD_FILE commands. On the command line, the Username (or USERID) must be the first parameter.ĬONTINUE_CLIENT Return to logging mode. Options can be supplied as part of the EXPDP command line or within an export parameter file. Syntax: EXPDP username/ connect_string ATTACH job_name]ĮXPDP username/ connect_string FULL=Y optionsĮXPDP username/ connect_string SCHEMAS= schema_nameĮXPDP username/ connect_string TABLES= table_name ĮXPDP username/ connect_string TABLESPACES= tablespace_nameĮXPDP username/ connect_string TRANSPORT_TABLESPACES= tablespace_name ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |