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;

Comments

Popular posts from this blog

Project euler 169 found clue

Floyd-Warshall's algorithm