Create Oracle database, user, table space, set role permissions script

/* divided into four steps */
/* Step 1th: Create a temporary tablespace */
Create temporary tablespace contract_temp
Tempfile ' D:\oradata\contract_temp.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
/* Step 2nd: Create a data table space */
Create Tablespace Contract_data
Logging
DataFile ' D:\oradata\contract_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
/* 3rd step: Create user and specify Tablespace */
Create user contract identified by password
Default Tablespace contract_data
Temporary tablespace contract_temp;
/* Step 4th: Grant permissions to users */
Grant CONNECT,RESOURCE,DBA to contract;

Create Oracle database, user, table space, set role permissions script