Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 12th, 2009
-- first identify the existing tablespacesSELECT tablespace_name
ORDERBY1;-- check the current undo parametersSELECTVALUE, name
WHERE name LIKE'%undo%';-- create the new undo tablespace 'tempundo'CREATE UNDO TABLESPACE tempundo
SIZE 100M REUSE AUTOEXTEND ON
RETENTION NOGUARANTEE;-- now change the undo tablespace to the 'tempundo' spaceALTER SYSTEM SET undo_tablespace = TEMPUNDO SCOPE=BOTH;-- verify the change has been made correctlySELECTVALUE, name
WHERE name LIKE'%undo%';-- finally, remove the old file/tablespaceDROP TABLESPACE <previous_tablespace_name>
INCLUDING CONTENTS AND DATAFILES;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.