OraFAQ Forum: Server Utilities » Exp and Imp BLOBs with out the exp-imp utility

Home » RDBMS Server » Server Utilities » Exp and Imp BLOBs with out the exp-imp utility

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exp and Imp BLOBs with out the exp-imp utility [message #180352]

Mon, 03 July 2006 03:42

arunkathirvelu
Messages: 3
Registered: June 2006

Junior Member

Is there a method to export a table that contains a BLOB column and import that back with out the exp and imp utilities..? The reason being I need to produce the migration scripts that would be attempted from a machine that need not necessarily have these tools..

Arun

Report message to a moderator

Re: Exp and Imp BLOBs with out the exp-imp utility [message #180570 is a reply to message #180352]

Tue, 04 July 2006 04:13

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

You can always write a program (or PL/SQL block) to read the data and write it out to whatever format you want.

Suggestion: write it out in a SQL*Loader compatible format - it will allow you to easily load it back with the sqlldr utility.

Report message to a moderator

Previous Topic:	SQL*Loader: remove hexadecimal zero values
Next Topic:	how to open the .dmp file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 19:23:13 CDT 2024