Hello all
We are designing a new application.
This application stores files that were FTP to the clients
and keep then for resubmitting (if the user ask for them).
There are two formats:
1) Standard records whose internal format is known.
These files lets the user ask for a subset of the records,
i.e. all the records for branch xxxx
that were submitted in the last week, etc. .
2) Strange files that are moved as a file.
Here the application is not aware of the internal format,
i.e. excel files, and these files are going to be stored as Blob's
and the user can ask only for the whole file again.
I know that you can store Blob's in three ways: (already rtfm a little)
1) In the record (up to 4k), more goes to another tablespace.
2) In Oracle but in another tablespace (always).
3) As external files.
I would like to learn from your experience what is the best,
easiest to implement, easiest to admin, less demanding on Oracle
and all the good stuff.
TIA
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
