1、导出名字为A的表（这里会导出SEQUENCES及FUNCTION等内容）
expdp TEST
/
TEST
@orcl
schemas
=
TEST dumpfile
=
TEST.dmp DIRECTORY
=
db_bak EXCLUDE
=
TABLE
:\"
NOT
IN
\(\
'
A\
'
)\"
2、导出名字不为A的表（去掉NOT与我们习惯的正好相反）
expdp TEST
/
TEST
@orcl
schemas
=
TEST dumpfile
=
TEST.dmp DIRECTORY
=
db_bak EXCLUDE
=
TABLE
:\"
IN
\(\
'
A\
'
)\"
3、导入名字为A的表（这里会导入SEQUENCES及FUNCTION等内容）
impdp test
/
test
@orcl
DIRECTORY
=
db_bak DUMPFILE
=
test.DMP remap_schema
=
test:test EXCLUDE
=
TABLE
:\"
NOT
IN
\(\
'
A\
'
)\"
4、导入名字不为A的表（去掉NOT与我们习惯的正好相反）
impdp test
/
test
@orcl
DIRECTORY
=
db_bak DUMPFILE
=
test.DMP remap_schema
=
test:test EXCLUDE
=
TABLE
:\"
NOT
IN
\(\
'
A\
'
)\"
5、扩展，导入表名为EMP*的表
impdp test
/
test
@orcl
DIRECTORY
=
db_bak DUMPFILE
=
test.DMP remap_schema
=
test:test EXCLUDE
=
TABLE
:\"
NOT
LIKE
'
EMP%
'
\" 使用not like排除表名
