Best options in table in order to storage blob datatypes
chijarNov 24 2008 — edited Dec 8 2008dear 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.