Databases Reference
In-Depth Information
Table 13-4.
(
continued
)
Original imp Parameter
Similar Data Pump impdp Parameter
TABLESPACES
TRANSPORT_TABLESPACES
TOID_NOVALIDATE
N/A
TOUSER
REMAP_SCHEMA
TRANSPORT_TABLESPACE
TRANSPORT_TABLESPACES
TTS_OWNERS
N/A
VOLSIZE
N/A; Data Pump doesn't support tape devices.
Summary
Data Pump is an extremely powerful and feature-rich tool. If you haven't used Data Pump much, then I recommend
that you take some time to reread this chapter and work through the examples. This tool greatly simplifies tasks such
as moving users and data from one environment to another. You can export and import subsets of users, filter and
remap data via SQL and PL/SQL, rename users and tablespaces, compress, encrypt, and parallelize, all with one
command. It really is that powerful.
DBAs sometimes stick with the old
exp
/
imp
utilities because that's what they're familiar with (I'm occasionally
guilty of this). If you're running Oracle Database 11g Release 2, you can use the old
exp
/
imp
parameters and options
directly from the command line. Data Pump translates these parameters on the fly to Data Pump-specific syntax. This
feature nicely facilitates the migration from the old to the new. For reference, I've also provided a mapping of the old
exp
/
imp
syntax and how it relates to Data Pump commands.
Although Data Pump is an excellent tool for moving database objects and data from one environment to another,
sometimes you need to transfer large quantities of data to and from OS flat files. You use external tables to achieve this
task. This is the topic of the next chapter in this topic.
