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

reading blobs!

Hi all.

Can anyone tell me the simplest way to read blobs from a database table using toad.

I want to read and export the blob value and then re insert it into another database where blobs are missing.

How to insert blobs..
0
AmmarDJ
Asked:
AmmarDJ
  • 3
1 Solution
 
HuaMinChenBusiness AnalystCommented:
0
 
AmmarDJAuthor Commented:
I would like to export blobs from an oracle database using toad and re insert it into a sql server database using sql server management studio.
0
 
k_murli_krishnaCommented:
How to read BLOB's

http://www.dbforums.com/oracle/1060374-how-read-blobs.html

How to insert a Blob into a database using SQL Server Management Studio

http://stackoverflow.com/questions/1643627/how-to-insert-a-blob-into-a-database-using-sql-server-management-studio

Move data from one Oracle (also applicable to SQL Server) DB to another DB using Toad

http://dba.stackexchange.com/questions/18408/move-data-from-one-oracle-db-to-another-db-using-toad
0
 
AmmarDJAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for AmmarDJ's comment #a39265282

for the following reason:

none
0
 
AmmarDJAuthor Commented:
none
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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