-1

I have 2000+ records in my table .table has clob data . I want to save all records as single files on my local machine. I am using pl/sql developer and Oracle 11g database.

Prashant Mishra
  • 619
  • 9
  • 25
  • 2
    So you want 2000+ files each containing a record? I'm almost afraid to ask why. – mmmmmpie Feb 19 '15 at 14:27
  • Do you just want to export the clob column? I can't speak for PL/SQL Developer, but Toad has an option to export blob/clob/etc columns into individual files. Maybe PL/SQL Devloper has something similar? Or if not, maybe Oracle's SQL Developer has something? – Boneist Feb 19 '15 at 14:48
  • mmmmmpie :business need – Prashant Mishra Feb 19 '15 at 14:56

1 Answers1

0

There is a way to do this if you have access to the file system on your database. You can find the solution here.

Community
  • 1
  • 1
Shankar
  • 879
  • 8
  • 15