Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

error in exporting data from sql server2008 to oracle

Posted on 2011-09-13
4
273 Views
Last Modified: 2012-08-13
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
Comment
Question by:Balshe
  • 2
4 Comments
 
LVL 1

Author Comment

by:Balshe
ID: 36528120
Hi ,anybody here?
0
 
LVL 10

Accepted Solution

by:
sqlservr earned 250 total points
ID: 36528426
better try to send 600000 record and 6000000 records in two phases
0
 
LVL 1

Author Comment

by:Balshe
ID: 36528554
dear,
While i am using the wizard,so i think  i could not do what you advised
0
 
LVL 13

Assisted Solution

by:khairil
khairil earned 250 total points
ID: 36530043
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question