Home » SQL & PL/SQL » SQL & PL/SQL » Need Help in creating table with BLOB Column (Oracle 9i)
Need Help in creating table with BLOB Column [message #310903] Wed, 02 April 2008 15:39
Messages: 1
Registered: April 2008
Junior Member
Hi folks,

I need help in creating table with blob column.

Here are my criteria's
This table will be heavily used -- 200 to 400 objects per hour and size from 500kb to 1MB of each.
Insert will be done by simultaneous users.
Select will be done periodically to clear (every 1 min) to get the object out and clean up space.

Please help me in creating table with proper index and chunk size where write and read will be efficient. Could you advice whether to use cache or not.


I used default table creation to create table and i have 10% of failure rate. Oracle did not throw any error. I am using Microsoft Oracle driver and .Net code to read and write into oracle.


[Updated on: Wed, 02 April 2008 15:41]

Report message to a moderator

Previous Topic: how to avoid hard code logic value all over pl/sql application?
Next Topic: Timezone conversion
Goto Forum:

Current Time: Mon Jul 24 04:09:08 CDT 2017

Total time taken to generate the page: 0.17671 seconds