Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
54
|
Oracle DBA Pocket Guide
TABLES = [schema_name.]table_name[:partition_name][, ...]
Specifies that you want to perform a table-mode opera-
tion, and provides the name of one or more tables.
TABLESPACES = tablespace_name[, ...]
Specifies a list of tablespace names to be exported or
imported in tablespace mode.
TRANSFORM = {SEGMENT_ATTRIBUTES = {Y | N} |
STORAGE = {Y | N}} [:{TABLE | INDEX}]
Available only with Data Pump Import. Specifies that
object creation DDL is to be altered for specific objects
being loaded. If SEGMENT_ATTRIBUTES is specified as
Y (the default), then segment attributes (physical
attributes, storage attributes, tablespaces, and logging)
are included, with appropriate DDL. If STORAGE is set
to Y (the default), then storage clauses are included, with
appropriate DDL. If TABLE or INDEX is supplied, the
transform will apply to that.
TRANSPORT_DATAFILES = datafile [, datafile …]
Available only with Data Pump Import. Specifies one or
more datafiles to be imported into the target database by
a transportable-mode import.
TRANSPORT_FULL_CHECK = {Y | N}
Specifies whether or not to check for dependencies
between those objects inside the transportable set and
those outside the transportable set. If Y is specified, then
Export or Import verifies that there are no dependencies.
TRANSPORT_TABLESPACES = tablespace [, tablespace ...]
Specifies that you want to perform a transportable-
tablespace-mode ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843