Guest User

Untitled

a guest
Apr 20th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. CREATE UNDO TABLESPACE undotbs2
  2. DATAFILE '/01/oradata/dbname/undotbs201.dbf'
  3. SIZE 50M AUTOEXTEND ON NEXT 5M;
  4.  
  5. Tablespace created.
  6.  
  7. ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2 SCOPE=BOTH;
  8.  
  9. DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES;
  10.  
  11. *
  12. ERROR at line 1:
  13. ORA-30013: undo tablespace 'UNDOTBS1' is currently in use
  14.  
  15. SYS@ecs01> alter tablespace undotbs1 offline;
  16.  
  17. Tablespace altered.
  18. SYS@ecs01> DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES;
  19.  
  20. Tablespace dropped.
Add Comment
Please, Sign In to add comment