Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    25

    Unanswered: Question about import

    Hi!!!
    When I do import, I sad IGNORE=y. But Oracle leaves the existing rows. Is it possible to say Oracle to erase all existing rows and then make import?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    IGNORE=Y ignores only CREATE errors; for example, if your export file contains only one table, IMP un/pw FILE=file.dmp would first attempt to CREATE TABLE your_table and, second, insert data into it. If the table already exists, IMP will fail.

    If you want to import data into an empty table, you'll have to remove records using, for example, TRUNCATE command (and include IGNORE=Y), or DROP the table.

  3. #3
    Join Date
    Jul 2004
    Posts
    25
    It's very bad!!!
    DB2 have this possibility (to replace existing rows).

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Hummm .... Another reason Oracle's the leader !!!

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Howevwer, not all is gloomy. If you specify IGNORE=Y and you are importing data that violates a primary key or unique index, the record will be ignored and your import will continue with an error message.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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