Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing huge XML files in DB or keep on filesystem

719416Aug 26 2009 — edited Aug 27 2009
Is it a good idea to keep huge files in DB or keep them on filesystem. Users upload file which gets processed and the data is stored in respective tables. The files are copied to filesystem. Some of my colleagues suggested store the files in DB. Over a period of 1 year of so the files takes close to 3-4 terabytes of space.

The database to keep the file and database to store the data will be different. Should we keep in same database? If we keep in separate database then we have to manage the transaction, isn't it? Is there any advantage at all to keep the files in DB?

There is a disaster recovery site as well so the data gets synced to the DR site. We are looking to use disk storage sync between the two sites so even if I keep files in filesystem and the related data in database the DR site will never be in a position where the file system and database is not in sync.

We are planning to use Oracle 11G Standard Edition.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2009
Added on Aug 26 2009
2 comments
632 views