Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Community (OTN)
Collaboration Suite Archived Forums
This discussion is archived
on Jun 22, 2009 6:01 PM by user10485386
Exporting all Storage Database BLOBS and CLOBS to the filesystem
Jan 24, 2008 9:23 AM
as written in the subject i want to export ALL the documents which are stored in the Collaboration Suite (Oracle Files in detail). I think the documents are stored in the Storage Database.
So does anyone know the tables etc. in that i could find the docs?
If you have a few SQL Statements that would be wonderful.
Also, it would be perfect if the file names and extensions AND the path used in Oracle Files could be exported to the filesystem.
I have written a Java programm which could do the work, but i don't know how the Storage DB stores the Oracle Files documents.
This content has been marked as final.
Show 1 reply
Re: Exporting all Storage Database BLOBS and CLOBS to the filesystem
Jun 22, 2009 6:01 PM
in response to
Did you figured out how to retrieve the file name and extension? I want to do the same thing but don't know where to look