Thanks for the response, unfortunately the application requires the
data
to be stored in the database, loading the files as BFILE type and then
using
DBMS_LOB.READ is not possible.
Darren
-Original Message-
Sent: Thursday, October 09, 2003 10:10 AM
To: Multiple recipients of list ORACLE
Undo cannot be "turned off" because without commit/rollback capability,
RDBMS can no longer manage resources and cannot observe ACID properties.
What you can do is to load files as BFILE type, which, essentially,
means that you are copying them to file system and just recording the
pathname into t
We are trying to load 23Gb's of raster images into our 9.2.0.2/Rac
Database, using ESRI's SDE GIS package,
and as usual there is a big rush to load the data.
If we try to load 14 images at one time, we run out of undo space
(datafile is currently 2 Gb). I could simply add another
datafile and no