Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to use EXCLUDE/INCLUDE in Datapump". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

I. usage

Single value

INCLUDE=TABLE: "= 'EMP'"

INCLUDE=TABLE: "= 'DEPT'"

Multi-value

INCLUDE=TABLE: "IN ('EMP',' DEPT')"

Fuzzy matching

INCLUDE=TABLE: "LIKE'% E%'"

INCLUDE=TABLE: "LIKE'% P%'"

II. Translation of quotation marks

Windows:

D:\ > expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott INCLUDE=TABLE:\ "IN ('EMP',' DEP')\"

Unix:

% expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott INCLUDE=TABLE:\ "IN\ 'EMP\',\ 'DEP\' 3. Content

To determine the names and exclusions of the object types that can be specified, including, you can run the following query:

Database-level import and export export/import:

SELECT named, object_path, comments FROM database_export_objects WHERE object_path NOT LIKE'% /%'

Table structure level import and export export/import:

SELECT named, object_path, comments FROM schema_export_objects WHERE object_path NOT LIKE'% /%'

Table-level import and export export/import:

SELECT named, object_path, comments FROM table_export_objects WHERE object_path NOT LIKE'% /%'

For TABLE dependent object types (10.2.0.x only):

SELECT named, object_path, comments FROM database_export_objects WHERE object_path LIKE 'TABLE/%'; "how to use EXCLUDE/INCLUDE in Datapump" is introduced here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.