Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    12

    Unanswered: Error during Import Dump file

    Dear Experts,

    I'm importing dumpfile into my database, but some of the data is rejected due to ORACLE error 1. Have anyone experienced this before?

    Any input would be very much appreciated.

    Thank you so much.

    Warmest regards,
    Sulaiman Aziz
    Attached Thumbnails Attached Thumbnails error import file.png  

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Have anyone experienced this before?
    yes.
    PK/UNIQUE index prevents duplicate value from INSERT
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2011
    Posts
    12
    Thanks for thr prompt reply, really apprecite it.

    Actually, I have imported the dumpfile into the data base before this. Because I want to get the latest data, I want to import latest dumpfile.

    So basically, the error is due to the data that is going to be imported is already there and cannot be duplicate, isn't it? My apology, to be honest, I'm still new with Oracle.

    Thanks again.

    Warmest regards,
    Sulaiman Aziz

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >So basically, the error is due to the data that is going to be imported is already there and cannot be duplicate, isn't it?

    You are correct.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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