| import issue..! [message #125570] |
Mon, 27 June 2005 15:42  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai ,
we would like to import the database from the full export taken.it has 15 files of 2g each. during the process we got the error, ora-03113 end -of -file on communication channel and it stucks up.how to resolve this..?.so now when we need to import again what to do..? since already imported objects are there, we dropped all the imported objects and started again the process.however stucks up with ora-03113.
shall we give grants=y,ignore=y,commit=y added to the old...?when i did this , it gives the following error recursively.
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint violated
how to tackle to import the full export containing some 400 tables while 280 only imported...?
plz help out.
DB-->oracle 9i
OS-->linux
bala
[Updated on: Mon, 27 June 2005 16:06] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
