• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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)
0
Balshe
Asked:
Balshe
  • 2
2 Solutions
 
BalsheAuthor Commented:
Hi ,anybody here?
0
 
Ramesh Babu VavillaCommented:
better try to send 600000 record and 6000000 records in two phases
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now