(Différences entre les versions)
Version du 10 novembre 2011 à 20:04
TEMP
UNDO
1 CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘/vol1/oracle/oradata/oracle1/undotbs02.dbf’ SIZE 50 M AUTOEXTEND OFF ;
2 ALTER SYSTEM SET undo_tablespace = UNDOTBS2 ;
3 DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES ;
4 CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ‘/vol1/oracle/oradata/oracle1/undotbs01.dbf’ SIZE 500 M AUTOEXTEND ON NEXT 5 M ;
5 ALTER SYSTEM SET undo_tablespace = UNDOTBS1 ;
6 DROP TABLESPACE undotbs2 INCLUDING CONTENTS AND DATAFILES ;