RE: Import question

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 15 Mar 2006 15:52:33 -0000
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0A189FE2@ENYC11P32005.corpny.csfb.com>

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_at_credit-suisse.com
212.538.1143

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Dunn Sent: Wednesday, March 15, 2006 10:47 AM To: Oracle-L_at_freelists.org
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

--

http://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

---

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 15 2006 - 09:52:33 CST