Home » RDBMS Server » Server Utilities » import issue (windows 2003)
import issue [message #277708] Wed, 31 October 2007 04:46 Go to next message
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
Re: import issue [message #277731 is a reply to message #277708] Wed, 31 October 2007 05:38 Go to previous messageGo to next message
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?
Re: import issue [message #277743 is a reply to message #277731] Wed, 31 October 2007 06:14 Go to previous messageGo to next message
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
Re: import issue [message #277756 is a reply to message #277708] Wed, 31 October 2007 06:55 Go to previous messageGo to next message
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.
Re: import issue [message #277757 is a reply to message #277708] Wed, 31 October 2007 06:59 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Is it stopped again? Or running ??
Previous Topic: sql loader problems
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Mon Dec 05 15:03:45 CST 2016

Total time taken to generate the page: 0.16255 seconds