RE: Import question
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'jdunn@xxxxxxxxx'" <jdunn@xxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 15 Mar 2006 15:52:33 -0000
Depends on the version. If "traditional" import (imp.exe), you cannot replace
a table if it already exists; you can only insert the export file's data into
it (ignore=y) IF the structure is identical.
With 10g impdp you have the option of TABLE_EXISTS_ACTION=REPLACE.
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxxxxxxx
212.538.1143
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of John Dunn
Sent: Wednesday, March 15, 2006 10:47 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Import question
I've RTFMd but still not clear on this....when doing a user import can I get
import to destroy/overwrite the existing objects owned by that user?
John
--
//www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
