 |
|
Oracle Tips by Burleson |
Oracle 10g External Tables Unload
You can now unload and transform large volumes of
data into a platform-independent flat file for data propagation or
storage, either serially or in parallel. To unload data using an
external table, utilize the Oracle Database 10g new feature called
the oracle_datapump access driver.
In versions prior to Oracle Database 10g, the
only access method available for Oracle external tables was
oracle_loader, essentially a sqlloader interface that only allowed
reading from external tables into the Oracle database. Now, with the
advent of the oracle_datapump, we can unload internal tables in
external flat files as well.
CREATE
TABLE proj_ext
ORGANIZATION EXTERNAL (TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY
proj_dir
ACCESS
PARAMETERS (LOGFILE log_dir:proj) LOCATION ('proj_dmp'))
AS SELECT
* FROM pl.projects;
The
primary clause that determines if an external table is used for
loading or unloading is the access_parameters clause that follows
the ORGANIZATION EXTERNAL in the above example.
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
