Monday, January 21, 2013

Oracle11g create Tablespace

First We Should Drop Tablespace if it exist

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