Oracle Creates table space users

1. Create normal table spaces and users

Create a temporary table space
Create temporary tablespace oa_temp
Tempfile ' D:\app\Administrator\oradata\orcldjoa_temp.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 20480m
Extent management Local;

Create a data table space
Create Tablespace OA
Logging
DataFile ' D:\app\Administrator\oradata\orcldjoa.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 20480m
Extent management Local;

Create user
Create user OA identified by OA
Default Tablespace OA
Temporary tablespace oa_temp;

Add permissions to a user
GRANT Create User,drop user,alter USER, create any VIEW,
DROP any view,exp_full_database,imp_full_database,
Dba,connect,resource,create SESSION to OA

Drop user OA cascade;
Drop tablespace OA including contents and datafiles;
Drop tablespace oa_temp including contents and datafiles;

2. Create large table spaces and users

Create a temporary table space
Create Bigfile temporary tablespace sxybyj_temp
Tempfile ' E:\app\Administrator\oradata\orcl\sxybyj_temp.dbf '
Size 128m
Autoextend on
Extent Management Local
Uniform size 128k

Create a data table space
Create Bigfile tablespace Sxybyj
DataFile ' E:\app\Administrator\oradata\orcl\sxybyj.dbf '
Size 128m
Autoextend on
Extent Management Local
Uniform size 128k

Create user
Create user Sxybyj identified by Sxybyj
Default Tablespace Sxybyj
Temporary tablespace sxybyj_temp;

Add permissions to a user
GRANT Create User,drop user,alter USER, create any VIEW,
DROP any view,exp_full_database,imp_full_database,
Dba,connect,resource,create SESSION to Sxybyj

Drop user Sxybyj cascade;
Drop user test1 cascade;
Drop tablespace sxybyj including contents and datafiles;
Drop tablespace sxybyj_temp including contents and datafiles;

Oracle Creates table space users