OraFAQ Forum: Server Administration » undo TS moving to Pending Switch-Out state

Home » RDBMS Server » Server Administration » undo TS moving to Pending Switch-Out state

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

undo TS moving to Pending Switch-Out state [message #57693]

Tue, 01 July 2003 03:16

DaDuck
Messages: 2
Registered: July 2003

Junior Member

High,

I've created an stored procedure to shrink a undo TS.
I actualy create a TMP_UNDO tablespace, switch (alter system set undo_tablespace= scope=memory).
Drop the org undo ts and recreate is with a smaller size.

However, after switching i am not alway able to offline the org tablespace. I get an Ora-30042:Unable to offline the undo TS.
This error is always returned when using the procedure. This is in a test db, where i'm the only one logged in (sqlplus /nolog).

Lookin in de alert.log it states:
Undo tablespace 1 moved to Pending Switch-Out State.

What does this mean? Hoe can i make sure the undo TS is not being used anymore, so i can offline it?

Thanks

Report message to a moderator

Previous Topic:	refreshing snapshot with unique index
Next Topic:	Can You Help me Creating index for the Given Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:27:17 CDT 2024