1, export the name of a table (here will export sequences and function and other content)
EXPDP Test/test@orcl schemas=Test DumpFile=test.dmp DIRECTORY=Db_bak EXCLUDE=TABLE: \ "not in \ (\'a\') \"
2, export the name is not a table (remove not and we are accustomed to the exact opposite)
EXPDP Test/test@orcl schemas=Test DumpFile=test.dmp DIRECTORY=Db_bak EXCLUDE=TABLE: \ "in \ (\'a\') \"
3, import the name of a table (here will import sequences and function and other content)
IMPDP Test/test@orcl DIRECTORY=db_bak dumpfile=test. DMP Remap_schema=test:test EXCLUDE=TABLE: \ "not in \ (\'A \') \ "
4, import the name is not a table (remove not and we are accustomed to the exact opposite)
IMPDP Test/test@orcl DIRECTORY=db_bak dumpfile=test. DMP Remap_schema=test:test EXCLUDE=TABLE: \ "not in \ (\'A \') \ "
5. Extension, import table named emp*
IMPDP Test/test@orcl DIRECTORY=db_bak dumpfile=test. DMP Remap_schema=test:test EXCLUDE=TABLE: \ " not like" emp%'\ ' excludes table names with not
Oracle uses a data pump to import and export some tables