Re: Snapshot too old in undo tablespace in 9i?

2003-08-15 Thread Stephen . HODGKINSON
un.com> cc: Sent by: Subject: Re: Snapshot too old in undo tablespace in 9i?

Re: Snapshot too old in undo tablespace in 9i?

2003-08-15 Thread Daniel Fink
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

Re: Snapshot too old in undo tablespace in 9i?

2003-08-15 Thread Stephen . HODGKINSON
un.com> cc: Sent by: Subject: Re: Snapshot too old in undo tablespace in 9i?

Re: Snapshot too old in undo tablespace in 9i?

2003-08-14 Thread Daniel Fink
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

Snapshot too old in undo tablespace in 9i?

2003-08-06 Thread Guerra, Abraham J
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

RE: Snapshot too old in undo tablespace in 9i?

2003-08-05 Thread Guerra, Abraham J
cc: Sent by: Subject: Snapshot too old in undo tablespace in 9i?

Re: Snapshot too old in undo tablespace in 9i?

2003-08-05 Thread Thomas Day
Sent by: Subject: Snapshot too old in undo tablespace in 9i?