About

Archives

Powered By

Calendar

September 2007
Sun Mon Tue Wed Thu Fri Sat
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30            

Categories

Mirrors

Alternatives

Copyright

  • All works Copyright © 1995-2004 Eyck, unless stated otherwise

Moving undo/temporary tablespace to another location

 
CREATE UNDO TABLESPACE undotbs02
DATAFILE '/opt/oracle/oradata1/sbrd/undotbs02.dbf' SIZE 3000M REUSE   
AUTOEXTEND ON;

ALTER SYSTEM SET UNDO_TABLESPACE = undotbs02;

DROP TABLESPACE undotbs01;

| Moving undo/temporary tablespace to another location | | 2003.11.26-11:25.00

 You are scrupulously honest, frank, and straightforward. Therefore you have few friends.