一、表导出导入
导出表Article_Detail:
expdp wdm_app_2
/
1234
@orcl_9
tables
=
ARTICLE_DETAIL directory
=
DATA_PUMP_DIR dumpfile
=
Article_Detail.dmp logfile
=
Expdp_Article_Detail.
log
compression
=
NONE content
=ALL
reuse_dumpfiles
=
y parallel
=
4
导入表Article_Detail:
impdp wdm_app_2
/
1234
@orcl_9
tables
=
Article_Detail directory
=
TEST_DUMP_DIR dumpfile
=
Article_Detail.DMP logfile
=
Impdp_Article_Detail.
log
table_exists_action
=
APPEND data_options
=
SKIP_CONSTRAINT_ERRORS parallel
=
2
二、查询导出导入
查询导出(导出文件名按日期方式),分二步走:
第一步,写一个Expdp_Query_Article_Detail.sql,写入以下内容:
column
today new_val dt
select to_char(sysdate, ' dd-mm-yyyy-hh24mi ' ) today from dual;
host expdp wdm_app_2 / 1234 @orcl_9 query = article_detail:\" where Website_No = ' NW41 ' \" tables = article_detail directory = TEST_DUMP_DIR dumpfile = Article_Detail_Query_ & dt..dmp logfile = Article_Detail_Query_ & dt.. log content =ALL reuse_dumpfiles = y parallel = 2
exit
select to_char(sysdate, ' dd-mm-yyyy-hh24mi ' ) today from dual;
host expdp wdm_app_2 / 1234 @orcl_9 query = article_detail:\" where Website_No = ' NW41 ' \" tables = article_detail directory = TEST_DUMP_DIR dumpfile = Article_Detail_Query_ & dt..dmp logfile = Article_Detail_Query_ & dt.. log content =ALL reuse_dumpfiles = y parallel = 2
exit
第二步,作一个批处理(如Expdp_Query_Article_Detail.bat),写入以下内容
echo
off
sqlplus wdm_app_2 / 1234 @orcl_9 @Expdp_Query_Article_Detail .sql
sqlplus wdm_app_2 / 1234 @orcl_9 @Expdp_Query_Article_Detail .sql
双击批处理Expdp_Query_Article_Detail.bat即可完成查询导出工作。
查询导入:
impdp wdm_app_2
/
1234
@orcl_9
tables
=
Article_Detail directory
=
TEST_DUMP_DIR dumpfile
=
ARTICLE_DETAIL_QUERY_17
-
12
-
2009
-
1756
.DMP logfile
=
Article_Detail.
log
table_exists_action
=
APPEND data_options
=
SKIP_CONSTRAINT_ERRORS parallel
=
2