OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import issue (windows 2003)

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

import issue [message #277708]

Wed, 31 October 2007 04:46

sellafrica
Messages: 68
Registered: July 2005
Location: Braynston

Member

hi all,

I having an import that stops without any errors,the import has more than one dump file and the export went through without errors.

My imp looks like this:

imp username/pass file=1.dmp,2.dmp,3.dmp full=y buffer=600000 filesize=524288000

Please assist.

Regards
Stanley

Report message to a moderator

Re: import issue [message #277731 is a reply to message #277708]

Wed, 31 October 2007 05:38

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Oracle version? Have you sufficient disk space or sufficient free space in tablespaces?

Report message to a moderator

Re: import issue [message #277743 is a reply to message #277731]

Wed, 31 October 2007 06:14

sellafrica
Messages: 68
Registered: July 2005
Location: Braynston

Member

Its oracle 8i,i was not having space on Users tablespaces,i have added it and going to start the import again

Report message to a moderator

Re: import issue [message #277756 is a reply to message #277708]

Wed, 31 October 2007 06:55

sellafrica
Messages: 68
Registered: July 2005
Location: Braynston

Member

i have lloked on toad and there is 1 row inserted but only one colum has "HugeBlob" inserted.

Report message to a moderator

Re: import issue [message #277757 is a reply to message #277708]

Wed, 31 October 2007 06:59

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Is it stopped again? Or running ??

Report message to a moderator

Previous Topic:	sql loader problems
Next Topic:	SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:24:12 CDT 2024