error in exporting data from sql server2008 to oracle

when i try to export records from sql server 2008 table(about 1300000 records) to oracle 11g  using the wizard in sql server 2008 management studio, and after exporting about 30000 records the export is stopped and get the below error :

not enough storage is available to process this command (system.drawing)
LVL 1
BalsheAsked:
Who is Participating?
 
Ramesh Babu VavillaCommented:
better try to send 600000 record and 6000000 records in two phases
0
 
BalsheAuthor Commented:
Hi ,anybody here?
0
 
BalsheAuthor Commented:
dear,
While i am using the wizard,so i think  i could not do what you advised
0
 
khairilCommented:
Hi,

Instead of running the wizard directly, save it to text file first then double click to execute later. The UI use Execute Package Utility might be less demanding on hardware.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.