Gene,
Are you using Automatic (System Managed) UNDO? or the traditional
Rollback segment method?
If you are using Automatic UNDO, you should have more than 2
segments in the UNDO tablespace. The number of segments initially created is
the function of processes and the minimum I have been able to create is 4
undo segments.
The problem you describe sounds more like a Rollback Segment
problem. Unless there is a transaction in the 'other' rollback segment, it
will not be shrunk. Check out www.optimaldba.com/library.html and
www.evdbt.com/papers.htm for papers on Undo Internals and ORA-01555. They
should explain your situation.
Dan Fink
-----Original Message-----
Sent: Tuesday, January 07, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Hi all:
I'm seeing something odd with the undo segments in
Oracle 9.2. I have a 1G undo tablespace and am
trying to import a 200M table. This is the only
transaction going on at the time and it is failing
because it is running out of space. When I check the
undo segments I see TWO undo segments of a significant
size. One that is used by my import and one more,
which eats up about a half of the tablespace. I
thought that Oracle would use up the space taken by
this "other" segment, but it doesn't and my import
fails. What am I not knowing about the undo segments
and oracle9.2?
thanks for any help
Gene
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gurelei
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fink, Dan
INET: [EMAIL PROTECTED]
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: [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).
