balaji1482 Messages: 149 Registered: July 2007 Location: INDIA
Senior Member
hi all,
i created new undo tablespace called 'UNDOTBS_02'. previously it was 'UNDOTBS_01' was created during database creation and the undo mode has been set to AUTO.then i decided to switch to new undo tablespace UNDOTBS_02 using the ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_02; and the command was sucessful.
When i tried to drop the old undo tablespace UNDOTBS_01 it says the tablespace does not exists. but when i query the view dba_free_space it shows me the old tablespace UNDOTBS_01.
i dont want the old tablespace to exist in my database.
gopu_g Messages: 50 Registered: March 2008 Location: mumbai
Member
hi
An undo tablespace can only be dropped if it is not currently used by any instance. If the undo tablespace contains any outstanding transactions (for example, a transaction died but has not yet been recovered), the DROP TABLESPACE statement fails. However, since DROP TABLESPACE drops an undo tablespace even if it contains unexpired undo information (within retention period), you must be careful not to drop an undo tablespace if undo information is needed by some existing queries
]
Members
Search
Help
Register
Login
Home
Re: Undo Tablespace
