Sign in or 
Share this
Data Import and Export
Oracle provides several methods which one can use to perform logical database backup and recovery. Of these, the common utilities used are the import and export tools. Many times they are used to move schema definitions and data between different Oracle instances and users.
While still supported on 10g the original import (imp) and export (exp) utilities were replaced in 10g with the faster and more advanced Data Pump-based, impdp and expdp.
On 11g just imp will be still available, so if you using 10g, now is the time to starting using data pump.
If you're using Oracle9i or earlier, and are looking for more information on using the original utilities, see this page. If you're using 10g or 11g, more information on the Data Pump-based utilities can be found here.
While still supported on 10g the original import (imp) and export (exp) utilities were replaced in 10g with the faster and more advanced Data Pump-based, impdp and expdp.
On 11g just imp will be still available, so if you using 10g, now is the time to starting using data pump.
If you're using Oracle9i or earlier, and are looking for more information on using the original utilities, see this page. If you're using 10g or 11g, more information on the Data Pump-based utilities can be found here.
HelioDias |
Latest page update: made by HelioDias
, Nov 30 2007, 12:10 PM EST
(about this update
About This Update
11g imp deprecated
- HelioDias
1 word added 1 word deleted view changes - complete history) |
|
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| psmith@epx.com | Data Pump.....and Compression? | 8 | May 17 2009, 6:43 PM EDT by atulrd | ||
|
Thread started: Dec 17 2007, 3:58 PM EST
Watch
A common technique used with exp/imp was compressing through a Pipe. Apparently this cannot be done with data pump "the ... dumpfile ... is no longer processed in a sequential manner" (Note:463336.1).
Certainly understandable up to the point of output to the named DUMPFILE...but beyond that point isn't this a fundamental violation of the accepted handling of Files in an UNIX environment? The specified DUMPFILE doesn't comply with what I've always understood to be the basic rules of Files in UNIX. Perhaps it might make some sense to allow the DUMPFILE one additional level of abstraction by using a BLOB or External Table for non-sequential assembly, the attaching this to a Standard File output which would adhere to the traditional conventions...once again allowing use of Pipes! Just an idea..... |
||||
| dbsoracle | Importing a sqlserver table that has an XML datatype | 0 | Dec 31 2008, 1:45 PM EST by dbsoracle | ||
|
Thread started: Dec 31 2008, 1:45 PM EST
Watch
Hello:
Does anyone know how to import into oracle a sqlserver table that has one of its columns being an XML datatype? Thank much, Don
1
out of
1 found this valuable.
Do you?
Keyword tags:
import+sqlserver
|
||||
| Alain.B. | Expdp Client side ? | 1 | Aug 22 2008, 2:31 AM EDT by astephan | ||
|
Thread started: Aug 20 2008, 5:10 AM EDT
Watch
Is there a way to use expdp from any client station and having the dumpfile also generated on that same station ?
Like old exp ?
2
out of
2 found this valuable.
Do you?
Keyword tags:
client side
exp
expdp
export
|
||||
Showing 3 of 3 threads for this page
