Data pump)

Data pump (Data Pump) first defines oracle: "Oracle data pump technology enables very high-speed movement of data and metadata from one database to another. "It sounds awesome. I don't want to consider it for the moment. First, I would like to take a few operations to enjoy. SQL> select * from v $ version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-ProdPL/SQL Release 10.2.0.3.0-ProductionCORE 10.2.0.productiont NS for 32-bit Windows: Version 10.2.0.3.0-ProductionNLSRTL Version 10.2.0.3.0-Production to view the predefined directory status SQL> select * from dba_directories; OWNER DIRECTORY_NAME DIRECTORY_PATH ------------------ has started SYS SUBDIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ order_entry \/2002/SepSYS xmldir c: \ oracle \ product \ 10.2. 0 \ db_1 \ demo \ schema \ order_entry \ SYS MEDIA_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ product_media \ SYS LOG_FILE_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ log \ SYS WORK_DIR C: \ ADE \ aime_vista_ship \ oracle/workSYS DATA_FILE_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ sales_history \ SYS DATA_PUMP_DIR C: \ oracle \ product \ 10.2.0 \ admin \ zmmctest \ dpdump \ SYS ADMIN_DIR C: \ ADE \ aime_vista_ship \ oracle/md/adm In has selected 8 lines under drive C New Data Pump import export data directory and log directory etl, etl_log and then use PL/SQL in the Database Registration just created Data Pump import export data directory and log directory SQL> create directory data_dir as 'C: the \ etl 'Directory has created the SQL> create directory log_dir as 'C: \ etl_log' directory, and then the read and write permissions of these two directories are granted to the user ASQL> grant read, write on directory data_dir to orabw authorized SQL> grant read, write on directory log_dir to orabw authorized SQL> select * from dba_directories; OWNER DIRECTORY_NAME DIRECTORY_PATH --------------------------- ----------------------- Export SYS LOG_DIR c: \ etl_logSYS DATA_DIR c: \ etlSYS subdir c: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ order_entry \/2002/SepSYS xmldir c: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ order_entry \ SYS MEDIA_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ product_media \ SYS LOG_FILE_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ lo G \ SYS WORK_DIR C: \ ADE \ aime_vista_ship \ oracle/workSYS DATA_FILE_DIR C: \ oracle \ product \ 10.2.0 \ db_1 \ demo \ schema \ sales_history \ SYS DATA_PUMP_DIR C: \ oracle \ product \ 10.2.0 \ admin \ zmmctest \ dpdump \ SYS ADMIN_DIR C: \ ADE \ aime_vista_ship \ oracle/md/admin has selected 10 rows and then in c: \ etl logs, contents: DIRECTORY = DATA_DIRUSERID = ORABW/ORABWTABLES = PRODUCTSCONTENT = ALLDUMPFILE = expdat. DMPLOGFILE = LOG_DIR: ETL_LOG. TXT execution export C: \ Documents ents and Settings \ Administrator> expdp parfile = c: \ etl \ expdp01.txtExport: Release 10.2.0.3.0-Production on Tuesday, 13 January 1, 2013 18: 40: 05 Copyright (c) 2003,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-ProductionWith the Partitioning, OLAP and Data Mining options to start "ORABW ". "SYS_EXPORT_TABLE_01": parfile = c: \ etl \ expdp01.txt is using BLOCKS Method for estimation... total estimation of the BLOCKS method used to process the object type TABLE_EXPORT/TABLE/TABLE_DATA: 0 KB processing object type TABLE_EXPORT/TABLE/INDEX processing object type TABLE_EXPORT/TABLE/CONSTRAINT processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS /INDEX_STATISTICS processing object type TABLE_EXPORT/TABLE/COMMENT processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS .. exported "ORABW ". "PRODUCTS" 120 KB 80 rows have successfully loaded/uninstalled the master table "ORABW ". "SYS_EXPORT_TA BLE_01 "************************************** **************************************** ORABW. the dump file set of SYS_EXPORT_TABLE_01 is: C: \ ETL \ EXPDAT. DMP job "ORABW ". "SYS_EXPORT_TABLE_01" was successfully completed at 18:40:15 so that the PRODUCTS information of the table is exported, including all objects related to the table. For more information, see the above information; then you can export the EXPDAT containing the table information. DMP can be imported to the corresponding database. You can also use a parfile or the exported file during the import. For example, C: \ Documents ents and Settings \ Administrator> impdp parfile = c: \ etl \ expdp01.txtImport: Release 10.2.0.3.0 -Production on Tuesday, 13 February 13, 2013 19: 07: 40 Copyright (c) 2003,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-ProductionWith the Partitioning, OLAP and Data Mining options have successfully loaded/uninstalled the main table "ORABW ". "SYS_IMPORT_TABLE_01" start "ORABW ". "SYS_IMPORT_TABLE_01": parfile = c: \ etl \ expdp01.txt processing object type TABLE_EXPORT/TABLE/TABLE_DATA .. imported "O" RABW ". "PRODUCTS" 120 KB 80 rows processing object type TABLE_EXPORT/TABLE/INDEX processing object type TABLE_EXPORT/TABLE/CONSTRAINT processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing TABLE_EXPORT/TABLE/COMMENT processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS job "ORABW ". "SYS_IMPORT_TABLE_01" was successfully completed at 19:07:45, so it came to an end.