EXCLUDE, INCLUDE, and QUERY provide powerful capabilities to developers
and database administrators during both export and import jobs.
Transforming Imported Objects
In addition to changing or selecting schemas, tablespaces, datafiles, and rows during the import,
you can change the segment attributes and storage requirements during import via the TRANSFORM
option. The format for TRANSFORM is as follows:
TRANSFORM = transform_name:value[:object_type]
Chapter 11: Backup and Recovery Options 409
The transform_name variable can have a value of SEGMENT_ATTRIBUTES or STORAGE. You
can use the value variable to include or exclude segment attributes (physical attributes such as
storage attributes, tablespaces, and logging). The object_type variable is optional, but if specified,
it must be one of these values:
CLUSTER
CONSTRAINT
INC_TYPE
INDEX
ROLLBACK_SEGMENT
TABLE
TABLESPACE
TYPE
For example, object storage requirements may change during an export/import; you may be
using the QUERY option to limit the rows imported or you may be importing only the metadata
without the table data. To eliminate the exported storage clauses from the imported tables, add
the following to the parameter file:
transform=storage:n:table
To eliminate the exported tablespace and storage clauses from all tables and indexes, use the
following:
transform=segment_attributes:n
When the objects are imported, they will be assigned to the user??™s default tablespace and will
use the default tablespace??™s storage parameters.
Pages:
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637