The EXCLUDE option in the preceding example contains a limiting condition within a set of
double quotes. The object_type variable can be any Oracle object type, including a grant, index,
or table. The name_clause variable restricts the value returned. For example, to exclude from the
export all tables whose names begin with TEMP, use the following EXCLUDE clause:
EXCLUDE=TABLE:"LIKE 'TEMP%'"
When you enter this at the command line on Linux, you may need to use escape characters
so the quotation marks and other special characters are properly passed to Oracle. Your expdp
command will look similar to this:
expdp rjb/rjb EXCLUDE=TABLE:\"LIKE \'TEMP%\'\"
NOTE
This example shows part of the syntax, not the full syntax for the
command.
If you do not provide a name_clause value, all objects of the specified type are excluded. For
example, to exclude all indexes, you would use an EXCLUDE clause similar to the following:
expdp rjb/rjb EXCLUDE=INDEX
For a listing of the objects you can filter, query the DATABASE_EXPORT_OBJECTS, SCHEMA_
EXPORT_OBJECTS, and TABLE_EXPORT_OBJECTS data dictionary views. If the object_type value
is CONSTRAINT, all constraints will be excluded except for NOT NULL. Additionally, constraints
needed for a table to be created successfully, such as a primary key constraint for an indexorganized
table, cannot be excluded. If the object_type value is USER, the user definitions are
excluded, but the objects within the user schemas will still be exported.
Pages:
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627