Shulou(Shulou.com)06/01 Report--

Usage 1. Single value

INCLUDE=TABLE: "= 'EMP'"

INCLUDE=TABLE: "= 'DEPT'"

2. Multi-value

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

3. Fuzzy matching

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

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

2. Translation of quotation marks 1. Windows:

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

2 、 Unix:

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

Content to determine the name and exclusion of the object types that can be specified, including, you can run the following query:

1. Import and export export/import at database level:

SELECT named, object_path, comments

FROM database_export_objects

WHERE object_path NOT LIKE'% /%'; 2. Import and export export/import at the table structure level:

SELECT named, object_path, comments

FROM schema_export_objects

WHERE object_path NOT LIKE'% /%'; 3. Table-level import and export export/import:

SELECT named, object_path, comments

FROM table_export_objects

WHERE object_path NOT LIKE'% /%'; 4. For TABLE dependent object types (10.2.0.x only):

SELECT named, object_path, comments

FROM database_export_objects

WHERE object_path LIKE 'TABLE/%'

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.