| import fails after 650 tables [message #62677] |
Mon, 09 August 2004 02:51  |
Chandra sing
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
I have an export file of size around 3 GB which has been exported from oracle 8.1.7 database. Now the database is corrupted . While importing it in oracle 9.0.1 database it imports 650 tables only. My system config is PIII 1Ghz. 250 MB ram and 40 GB HD.
I tried with another export file having 50 tables.It imported successfully . After that again I imported this file. It imported only 600 tables. Hence it maintains always 650 tables. Also , I have tried the indexfile option. It gives the scripts of 650 tables.But its not giving any erros or error message in log file. Simply aborts.
Kindly help me to resolve this problem.
Thanks in advance.
|
|
|
|
|
|
| Re: import fails after 650 tables [message #62679 is a reply to message #62678] |
Mon, 09 August 2004 04:31  |
Chandra sing
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
Hi
thanks for ur response.
i dont have neither the source database nor the export log file. Im using windows2000 server have enough space on the hard disk and the autoextend is on .
Is there any way to extract atleast the DDLs(table,index,triggers,procedures etc) other than indexfile option ?.
Thanks in advance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
