?
Solved

error in exporting data from sql server2008 to oracle

Posted on 2011-09-13
4
Medium Priority
?
276 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
[X]
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
  • 2
4 Comments
 
LVL 1

Author Comment

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

Accepted Solution

by:
Ramesh Babu Vavilla earned 1000 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 1000 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 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