导出分区表

转载于 2016-11-01 16:41:30 发布 · 99 阅读

expdp bi/bi@orcl directory=DATA_DIR dumpfile=bi%U.dmp tables=Bi_Fact_Aidsreports,Bi_Fact_Aidsreportsq,Bi_Fact_Aidsreportsy logfile=bi.log parallel=2 filesize=2000M

参考：

expdp hii/hiiCDjd@cdhii directory=DIR_DP dumpfile=hii_exdi_%U.dmp SCHEMAS=hii exclude=TABLE:\"in $\'IB_TBS_DETAILEDINF\'$\",TABLE:\"LIKE \'MLOG$%\'\",TABLE:\"LIKE \'RUPD$%\'\" logfile=exphii_nodi.log parallel=8 filesize=2000M content=DATA_ONLY

遇到问题
ORA-39095: 转储文件空间已耗尽: 无法分配 8192 字节

http://blog.csdn.net/wyzxg/article/details/5853272

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29050044/viewspace-2127437/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29050044/viewspace-2127437/