Overwritting existing tables using IMP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Overwritting existing tables using IMP

  1. #1
    Join Date
    Aug 2000
    Posts
    29
    Is there a command to overwrite existing tables of the same
    when using IMP73 of Oracle 7.3.4?

    Here is my exsiting cmd line parameters:

    IMP73 user/password file=c:\temp ignore=y commit=y

    thanks,
    scotta
    J.Scott Adams

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    ignore=y will just append data to the existing table, I don't think it's exactly what you want. You may want to truncate your tables OUTSIDE of import and then import with ignore=y.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    Truncate does not delete the child records. You may want to delete cascade also if you want to wipe the existing data out or you can disable the constraints.

    [Edited by kris109 on 07-09-2001 at 06:14 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width