DROP TABLESPACE UNDO INCLUDING CONTENTS AND DATAFILES;

CREATE UNDO TABLESPACE UNDO DATAFILE

‘/usr/lib/oracle/xe/oradata/XE/undo.dbf’ SIZE 500M AUTOEXTEND ON NEXT 5M MAXSIZE 500M

ONLINE

RETENTION NOGUARANTEE

BLOCKSIZE 8K

FLASHBACK ON;