Google Answers Logo
View Question
 
Q: Oracle tools to copy blob data ( No Answer,   4 Comments )
Question  
Subject: Oracle tools to copy blob data
Category: Computers > Software
Asked by: silverlake-ga
List Price: $5.00
Posted: 09 Nov 2004 12:06 PST
Expires: 09 Dec 2004 12:06 PST
Question ID: 426744
What would be the most convenient tool/method for moving blob data
from one Oracle database to another? I have a table containing 55
columns with a column of blob data type and others of varchar2, number
and date types. There are roughly 45000 records in the table. The task
is to copy all the data from this table to another table residing in
different database. Both database are Oracle 8i running on UNIX.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Oracle tools to copy blob data
From: scubajim-ga on 10 Nov 2004 13:06 PST
 
Use Oracle's own export and import utilities.  Export from one and
into the other.  go to otn.oracle.com and click on documentation.
Subject: Re: Oracle tools to copy blob data
From: upss-ga on 25 Nov 2004 20:32 PST
 
You may want to use thirdt party tool like FastReader wich
specializing in extract  / load data from Oracle. FastReader from
WisdomForce (http://www.wisdomforce.com) allows quickly to extract
large Oracle tables into flat files and generates control files for
sqlldr*. FastReader is supporting blob types.
Subject: Re: Oracle tools to copy blob data
From: upss-ga on 25 Nov 2004 20:37 PST
 
Forgot to mention that WisdomForce FastReader does support Oracle 8i on UNIX.
Subject: Re: Oracle tools to copy blob data
From: utamaru99-ga on 15 Mar 2005 01:16 PST
 
How about DataBaselink ?

insert target_tab (select  ... from source_tab@link);

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy