January 16th, 2004, 07:46 AM
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..
exp system@db1 file=c:\expdat.dmp log=c:\exp.log full=y buffer=10000000
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.
January 16th, 2004, 07:48 AM
It would be better to show us the error messages.
January 16th, 2004, 07:51 AM
cannot find out exact error or warning mess's right now, but "constrain conflicts" is what i remember...
January 16th, 2004, 08:10 AM
found the errors...
when oracle tries to replace an object that already exists...it all goes haywire
January 16th, 2004, 10:48 AM
You will need to drop the object if it already exists and you want to overwrite it.