OraFAQ Forum: Server Administration » import fails after 650 tables

Home » RDBMS Server » Server Administration » import fails after 650 tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: import fails after 650 tables [message #62678 is a reply to message #62677]

Mon, 09 August 2004 03:38

Gorjan Todorovski
Messages: 9
Registered: August 2004

Junior Member

Do you have the export log file. If yes, check if the other tables (other
than those 650) are actually exported.

-----
www.oracleclinic.com

Report message to a moderator

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.

Report message to a moderator

Re: import fails after 650 tables [message #62681 is a reply to message #62679]

Mon, 09 August 2004 04:36

Gorjan Todorovski
Messages: 9
Registered: August 2004

Junior Member

Did you try the SHOW=Y option with the imp utiltiy. It should just list
the commands used for createing objects.

-----
www.oracleclinic.com

Report message to a moderator

Re: import fails after 650 tables [message #62893 is a reply to message #62677]

Sun, 22 August 2004 22:09

Thomas
Messages: 67
Registered: September 1999

Member

Please, post your import parameter file (*.par) and the import log file (*.log).

It's hard to say what's happening w/o this information.

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups

Report message to a moderator

Previous Topic:	database upgrade
Next Topic:	CPU_PER_SESSION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:22:34 CDT 2024