Oracle New Table Space

/*divided into four steps*//*1th Step: Create a temporary table space*/Create Temporarytablespace slfph_temp tempfile'D:\oracledata\slfph_temp.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local;/*2nd Step: Create a data table space*/Createtablespace slfph_data Logging datafile'D:\oracledata\slfph_data.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local;/*3rd Step: Create a user and specify a tablespace*/Create UserSLFPH identified byslfphdefaulttablespace slfph_dataTemporarytablespace slfph_temp;/*4th Step: Grant permissions to the user*/GrantConnect,resource,dba toSLFPH;

Oracle New Table Space