Oracle creates tablespace, temp table space, user

Create tablespace a_dat datafile ' D:\oracle\product\10.2.0\oradata\orcl\a_dat.dbf ' size 1024m autoextend on next 100m max Size Unlimited;

Create temporary tablespace aa_dat_temp

Tempfile ' D:\oracle\product\10.2.0\oradata\orcl\a_dat_temp.dbf '

Size 1024M autoextend on next 100m MaxSize unlimited;

Create user Applyreleasesystem identified by Applyreleasesystem

Default Tablespace A_dat

Temporary tablespace a_dat_temp;

Grant CONNECT,RESOURCE,DBA to Applyreleasesystem;

Grant Create Session,create table,unlimited tablespace to Applyreleasesystem;

Oracle creates tablespace, temp table space, user