DROP TABLESPACE TODOLIST INCLUDING CONTENTS AND DATAFILES;
and Create
CREATE TABLESPACE TODOLIST DATAFILE
'/oracle/11g/oradata/orcl/todolist.dbf' SIZE 100M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
NOLOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
No comments:
Post a Comment