|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
||||
|
||||
|
It would be better to show us the error messages.
|
|
#3
|
|||
|
|||
|
cannot find out exact error or warning mess's right now, but "constrain conflicts" is what i remember...
|
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > importing an oracle dump to a new oracle db... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|