Oracel Create tablespace, user, Import Database

/* divided into four steps */
/* Step 1th: Create a temporary tablespace */
Create temporary tablespace csxaj_temp
Tempfile ' D:\oracle\oradata\scpinganka\csxaj_temp.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

/* Step 2nd: Create a data table space */
Create Tablespace Csxaj_data
Logging
DataFile ' D:\oracle\oradata\scpinganka\csxaj_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

/* 3rd step: Create user and specify Tablespace */
Create user csx_20150306 identified by csx_20150306
Default Tablespace csxaj_data
Temporary tablespace csxaj_temp;

/* Step 4th: Grant permissions to users */
Grant CONNECT,RESOURCE,DBA to csx_20150306;

/*imp Userid=csx_20150306/[email protected] full=y file=csx_20150130.dmp log=imp_csx_20150306 * *

Oracel Create tablespace, user, Import Database