OCP 9i DBA Fundamentals I vol1 page 311:
then all transactions are complete, and the tablespace can be dropped.
DROP TABLESPACE UNDOTBS;
The Oracle server may reference tablespace UNDOTBS after switching to another UNDO[/COLOR] tablespace to provide a consistent read for queries. Queries requiring information from tablespace UNDO1, after it is no longer available to provide a consistent read, receive the error: ORA-1555 snapshot too old.
为何 UNDOTBS drop 掉后, 还有可能被引用?