O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

External Table Enhancements

Along with the introduction of Oracle 10g Data Pump, the external table feature, which was introduced with Oracle 9i, also offers new improvements for data movement within the Oracle server. Prior to Oracle 10g, external table support was limited to only read-only access. This limitation meant you could load data only from a properly formatted external table.

With Oracle 10g, external tables can now be also written to through the use of the new ORACLE_DATAPUMP access driver. The major benefit of this new functionality is that it allows you to unload and transform large volumes of data into platform-independent flat files and use them for either data propagation or storage. Although neither DML (data manipulation language) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required