Databases Reference
In-Depth Information
With external tables we can also use a pre-processor program—which can range from
shell-scripts to the user-generated binaries—to pre-process input data. The limit to the
type of loadable formats relies on the user's ability to transform the original dataset.
Export and Import Data Pump utilities allow easy data and metadata transfer
between databases.
Data Pump is a new feature in Oracle Database 10
g
, and in Enterprise Edition it also
allows us to load or unload parallel multiple streams of data from the database.
There is also a network mode that allows remote export and import over the network. We
can export data from a database directly to our local disks, or import data from a database
to another database directly, without using any dump-file. The data is written directly from
one database to another database using the network.
You can find more on Data Pump in the Oracle Documentation:
http://download.oracle.com/docs/cd/E14072_01/
server.112/e10701/part_dp.htm
.
See also
F
The
Direct
path
inserting
recipe in this chapter
