create tablespace user_name
logging
datafile '/oracle/app/oradata/orcl/user_name.dbf' 
size 168m
autoextend on 
next 100m 
extent management local;

create temporary tablespace user_name_tem
tempfile '/oracle/app/oradata/orcl/user_name_tem.dbf' 
size 168m
autoextend on 
next 100m 
extent management local;

create user user_name
  identified by user_password
  default tablespace user_name
  temporary tablespace user_name_tem;

grant connect to user_name;
grant exp_full_database to user_name;
grant imp_full_database to user_name;
grant resource to user_name;
grant alter any table to user_name;
grant create any table to user_name;
grant create any view to user_name;
grant delete any table to user_name;
grant drop any table to user_name;
grant drop any view to user_name;
grant select any dictionary to user_name;
grant unlimited tablespace to user_name;