Oracle New Table Space

/* divided into four steps *//* 1th step: Create a temporary tablespace  */create temporary tablespace user_temp  tempfile ' D:\oracle\oradata\Oracle9i\user_ TEMP.DBF '//Temp tablespace storage location size 50m  //Table space Initial size autoextend on  //Open auto grow next 50m maxsize 20480m  //Auto Grow size 50M, Maximum value 20480Mextent management local;   /* 2nd step: Create data table space  */create tablespace user_data  logging  datafile ' D:\oracle\oradata\Oracle9i\user_ DATA.DBF ' size 50m  autoextend on  next 50m maxsize 20480m  extent management local;   /* 3rd step: Create user and specify Tablespace  */create user username identified by password  default tablespace user_data  Temporary Tablespace user_temp;   /* 4th step: Grant the user permission  */grant connect,resource,dba to username;

Oracle New Table Space