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

codefights smooth sailing ( CommonCharacterCount)

How to remove 8443 port in URL in tomcat