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!

Best options in table in order to storage blob datatypes

chijarNov 24 2008 — edited Dec 8 2008
dear all,
Facts:
- oracle 10g r2 (10.2.0.1)
- RHEL AS version 4 32 bits

1.- In a few days i have to decided if storage pdf files or storage pdf files in a file server.
Basically i have to demonstrate that size in a table grow and is more than if i will save this files in a file server.
what do you recommend me ???


2.- In case i have to save pdf files into table, what is the better option:
2.1- add a column into a table that was created few months ago ???
2.2- create a table with exclusive for blob column and a column that reference to another table (in order to locate the file). All of that in an exclusive tablespace. and the last question, what will be the best options (logging, extent management local, extent size etc.)

thanks a lot for your answers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2009
Added on Nov 24 2008
6 comments
1,368 views