ORACLE EXPDP AND IMPDPD

番茄你个西红4

已于 2023-03-08 10:21:09 修改

阅读量750

点赞数

分类专栏：导出文章标签： oracle

于 2020-06-08 17:04:41 首次发布

本文链接：https://blog.csdn.net/qq_21608393/article/details/106624015

版权

导出专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1,按用户导出表结构

expdp \'/ as sysdba \' cluster=no DUMPFILE=yscj2user1.dmp DIRECTORY=DATA_PUMP_DIR schemas=SJCK_JCSSJ,SJCK_ZFGSPT,SJCK_ST,SDS_TDAP,SJJC_QY,SJZBQ_HIST,SJCK_KHD,SJCK_SDS,SJCK_SJFX,SJCK_QY,SJCK_JCAG LOGFILE=yscj2user1.log content=metadata_only COMPRESSION=ALL;

--可排除exclude=STATISTICS

导入：impdp \'/ as sysdba \' cluster=no PARALLEL=8 directory=DATA_PUMP_DIR DUMPFILE=yscj2user1.dmp logfile=yscj2user1.log TABLE_EXISTS_ACTION=REPLACE

--导出指定表

expdp \"/ as sysdba\" DIRECTORY=DATA_PUMP_DIR dumpfile=ddh_0605.dmp logfile=ddh.log tables=GS_ZRRQFXF.SB_ZHSD_NDZXSB_ZB

impdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=ddh_0529.dmp logfile=ddh.log remap_schema=gs_zrrqfxf:sjjc_bz remap_tablespace=TS_GS_ZRRQFXF_DATA:TS_DAT_SJCK_BZ TABLE_EXISTS_ACTION=REPLACE

2.使用par文件按条件导出

dumpfile=dump_%u.dmp

directory=DUMPDIR

cluster=N
exclude=(statistics,index)

parallel=8

filesize=2G

tables=(A,B)
query=A:"where kpyf in(202212,202301'202302')",B:"where kpyf in(202212,202301,'202302')"