I am using Oracle 10g release 2 database in Unix
I lost the undo datafile , so I restarted my db and issued this statement
SQL> alter database datafile '/slot01/oracle/db/adnzn001/dbf/undotbs01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
In this case where will the undo data be stored , since the database is using automatic undo management
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 1800
undo_tablespace string APPS_UNDO_TBS
When I tried dropping undo tablespace its throwing error
SQL> drop tablespace APPS_UNDO_TBS;
drop tablespace APPS_UNDO_TBS
*
ERROR at line 1:
ORA-30013: undo tablespace 'APPS_UNDO_TBS' is currently in use
What does this mean ? where is the undo data stored since the datafile has been deleted from disk and also i dropped it using sql statement ?
] 
Blog
Search
Help
Members
Register
Login
Home
