Use the SCHEMA object_
type, as shown in an earlier example, to exclude a user and all of the user??™s objects. If the
object_type value is GRANT, all object grants and system privilege grants are excluded.
A second option, INCLUDE, is also available. When you use INCLUDE, only those objects
that pass the criteria are exported; all others are excluded. INCLUDE and EXCLUDE are mutually
exclusive. The format for INCLUDE is
INCLUDE = object_type[:name_clause] [, ...]
Chapter 11: Backup and Recovery Options 403
NOTE
You cannot specify INCLUDE if you specify CONTENT=DATA_ONLY.
For example, to export two specific tables and all procedures, your parameter file will include
two lines similar to the following:
INCLUDE=TABLE:"IN ('BOOKSHELF','BOOKSHELF_AUTHOR')"
INCLUDE=PROCEDURE
What rows will be exported for the objects that meet the EXCLUDE or INCLUDE criteria? By
default, all rows are exported for each table. You can use the QUERY option to limit the rows
returned. Here is the format for the QUERY parameter:
QUERY = [schema.][table_name:] query_clause
If you do not specify values for the schema and table_name variables, the query_clause will
be applied to all the exported tables. Because query_clause will usually include specific column
names, you should be very careful when selecting the tables to include in the export. You can
specify a QUERY value for a single table, as shown in the following example:
QUERY=BOOKSHELF:'"where rating > 2"'
As a result, the dump file will only contain rows from the BOOKSHELF table that meet the
QUERY criterion as well as any INCLUDE or EXCLUDE criteria.
Pages:
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628