oracle數(shù)據(jù)泵導(dǎo)出和導(dǎo)入-文庫吧資料
2025-07-04 07:57本頁面
【正文】 所有表包含與表相關(guān)的索引，備注等不包含過程等其它對象類型：expdp hs_his/handsomeHS2008 dumpfile= logfile= directory=TEST_EXPDP job_name=job_hisjob7 include=TABLE:\LIKE \39。注意：如果QUERY條件寫得有問題那么下面總是會報以下的錯誤ORA39001: invalid argument valueORA39035: Data filter SUBQUERY has already been specified.按表空間導(dǎo)出：Expdp system/mingyueHS2008 dumpfile= tablespaces=HS_HIS_DATA,HS_HIS_IDX logfile= directory=TEST_EXPDP job_name=hs_hisjob6。按查詢條件導(dǎo)出：expdp system/mingyueHS2008 tables= dumpfile = logfile= directory=TEST_EXPDP job_name=hs_hisjob2 query=39。[oracleLinuxRedHat expdpdump]$ expdp system/mingyue attach=system. HS_HISJOB。以前的EXP，如果退出交互式模式，就會出錯終止導(dǎo)出任務(wù)。Export: Release Production on 星期三, 10 11月, 2010 0:16:04Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsStarting SYSTEM.SYS_EXPORT_SCHEMA_01: system/********HS2008 schemas=hs_his,hs_futures dumpfile = logfile= directory=TEST_EXPDP Estimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPO
試題試卷相關(guān)推薦
鄂ICP備17016276號-1