FAQ
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

Search Discussions

  • Baumgartel, Paul at Mar 15, 2006 at 3:52 pm
    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
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 15, '06 at 3:46p
activeMar 15, '06 at 3:52p
posts2
users2
websiteoracle.com

2 users in discussion

Baumgartel, Paul: 1 post John Dunn: 1 post

People

Translate

site design / logo © 2022 Grokbase