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
44
|
Oracle DBA Pocket Guide
TOUSER = (username[, username ...])
Specifies a list of users whose schemas will be the target of
the import. If multiple users are specified, the names must
be paired with names in a corresponding FROMUSER
parameter, such as:
FROMUSER=(tom,dick) TOUSER=(harry,dave)
TTS_OWNERS = (ownername[, ownername ...])
Specifies the owners of an imported transportable
tablespace.
Data Pump Export and Import
The Data Pump Export and Import utilities were introduced
with Oracle Database 10g Release 1. They have similar func-
tionality and a similar look and feel to the original EXP and
IMP utilities. However, files created by Data Pump Export
are not compatible with files created by EXP; consequently,
files created by EXP cannot be imported with Data Pump
Import. Moreover, Oracle Database 10g features are fully
supported only by Data Pump. For this reason—and because
Data Pump provides improved performance—I recommend
that you use the new Data Pump utilities if you are running
Oracle Database10g.
Data Pump features
Data Pump Export and Import provide a variety of new
backup and recovery features:
You can specify the maximum number of threads of active
execution operating on behalf of the Data Pump job,
which allows the DBA to adjust resource consumption
versus elapsed time. Note that this feature is available only
with the Enterprise Edition for Oracle Database 10g.
You can restart Data Pump ...
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