windows环境, 被忽略的表不会创建表结构
-- 用in
impdp table_name/table_name directory=bingo dumpfile=table_name20211222.DMP REMAP_SCHEMA=table_name:table_name EXCLUDE=USER,table:\"in ('MESSAGE_LOG','DBC_XM','CH_BMF_TU')\"
-- 用like
impdp table_name/table_name directory=bingo dumpfile=table_name20211222.DMP REMAP_SCHEMA=table_name:table_name EXCLUDE=USER,table:\"like \'%MESSAGE_LOG%\'\",table:\"like \'%DBC_XM%\'\",table:\"like \'%CH_BMF_TU%\'\"
impdp导入排除指定表
最新推荐文章于 2024-07-26 00:24:43 发布