un.com> cc:
Sent by: Subject: Re: Snapshot too old in undo
tablespace in 9i?
Stephen,
Tim's statement is correct, but can be construed incorrectly if you read it and think
of TEMP segments. AUM still uses undo segments (same basic structure as rollback
segments). However, one of the space management steps is to allow an undo segment to
'steal' extents from another undo
un.com> cc:
Sent by: Subject: Re: Snapshot too old in undo
tablespace in 9i?
couple of hours longer than you think the
> export will take.
>
>
> "Guerra, Abraham
> J" ORACLE-L <[EMAIL PROTECTED]>
> @amfam.com> cc:
> Sent by: Subject: Snapshot too
Title: Message
Hello
Group,
I just upgraded
a database to Oracle 9.2.0.3 from 8.1.7. I created an undo tablespace with
10 (default) undo segments... however, during an export I got the following
message:
ORA-01555: snapshot too old: rollback segment
number 15 with name "_SYSSMU15$" too
cc:
Sent by: Subject: Snapshot too old in undo
tablespace in 9i?
Sent by: Subject: Snapshot too old in undo
tablespace in 9i?
I am converting to 9i and am thinking about using the undo tablespace rather than
rollback segments. Does anyone know if there are any performance implications in using
the undo tablespace? I tried a big import that ran 21 minutes using rollback segments
and 23 minutes using the undo tablespace