#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    3
    Rep Power
    0

    importing an oracle dump to a new oracle db...


    we have worked on an oracle db and now want to migrate it to the clients server...

    the problem is that not all data is imported followed by several warning & error messages..

    our side...

    exp system@db1 file=c:\expdat.dmp log=c:\exp.log full=y buffer=10000000

    client side...

    imp system@db2 file=c:\expdat.dmp log=c:\exp.log full=y ignore=y buffer=10000000

    ...so we're stuck here, the only problem being that not all data is imported.

    any insight appreciated..thanks in advance.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    It would be better to show us the error messages.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    3
    Rep Power
    0
    cannot find out exact error or warning mess's right now, but "constrain conflicts" is what i remember...
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    3
    Rep Power
    0
    found the errors...

    when oracle tries to replace an object that already exists...it all goes haywire


    IMP-00015:
    IMP-00017:
    IMP-00003:

    Oracle error:
    439
    1659
    942
    2430
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    You will need to drop the object if it already exists and you want to overwrite it.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

IMN logo majestic logo threadwatch logo seochat tools logo