Exporting data from Oracle Databases

by Andrew Albertson
by Andrew Albertson

There are two ways to export data from an Oracle 10g database. Data Pump or the Export utility.
The export utility has been around for quite some time, and prior to 10g was the only way to export data. But 10g introduced a new method called data pump.
Data Pump seems to be allot faster and more useful, but export is still necessary if you plan to then import the data into an older database. Although I have found you might have to use the version of export utility that is compatible with the database you plan to import into, rather than the ‘new’ version that comes with 10g.
The other thing to note is, that the command line syntax is very different.
Continue reading Exporting data from Oracle Databases