First page Back Continue Last page Graphics
External Tables…
New access driver ORACLE_DATAPUMP
- Used by datapump import and export
Can read and write to external files
- One-time load only
- No subsequent updates allowed
Use as another way to invoke datapump export / import
Notes:
Oracle10g provides a new external table access driver call ORACLE_DATAPUMP.
The difference between this access driver and the Oracle9i driver is that this new access driver has the ability to populate dump files. Note that this is a one-time write; after the initial load, only query is supported.
Earlier in this lesson we learned that sometimes datapump operations will choose to use external tables as the method of accessing data – either for importing dump files into permanent tables or for exporting permanent tables to a dump file. However, we can also make use of this driver ourselves. Next, we will look at an example of use ORACLE_DATAPUMP external tables as a means of exporting and importing data – without OS-level commands.