Results 1 to 3 of 3

Thread: Need help in IMP .dmp file

  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Need help in IMP .dmp file

    HI,

    I tried to import .dmp file in oracle.i supplied the follwoing command :-

    IMP ph1/ph1@test file=E:\test1.dmp full=y

    i got the follwoing error : " Following statement failed because the object is already exist"

    then i tried supplying the following command

    IMP ph1/ph1@test file=E:\test1.dmp full=y ignore=y

    i am getting this error :Row rejected due to oracle error1
    encountered , unique constraint violated <id name>.

    how can i proceed for the import.

    expecting a valuable support on this.

    Thanks.

  2. #2
    Join Date
    Jun 2008
    Posts
    1
    imp
    user/password@databasename
    file=E:\test1.dmp
    log = error.log
    from =user
    touser=user
    grants=n
    ignore=y

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you appending to existing table?. ignore=y ignores only object existence, if you have data the constraint may be violated if you have a row with same values for constraint columns.

    You can truncate the table and import again.

Posting Permissions

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