Turning off undo for one session

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Thu, 09 Oct 2003 08:44:25 -0800
Message-ID: <F001.005D291F.20031009084425@fatcity.com>

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 not worry about, but I figure that's the easy way out.

I have turned logging off for the table and the tablespace, but I can't figure out how to turn the creation of undo off for a particular session, or if it is even possible.

Thanks

Darren

---

---

Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_coquitlam.ca

---

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  INET: dbrowett_at_coquitlam.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Thu Oct 09 2003 - 11:44:25 CDT