![]() |
|
![]() | ||
|
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. |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
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); |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |