create temporary tablespace user_name_temp

tempfile '/oradata/ORA11G/user_name_temp.dbf'

size 50m

autoextend on

next 50m

maxsize unlimited

--maxsize 2048m 
extent management local;

create tablespace user_name_tb

logging

datafile '/oradata/ORA11G/user_name_tb2.dbf'

size 32m

autoextend on

next 32m maxsize unlimited

extent management local
default compress;

--有特殊字符需要加双引号
create user user_name identified by "123！"

default tablespace user_name_tb

temporary tablespace user_name_temp;

grant create session to user_name;

grant unlimited tablespace to user_name;

grant create any table to user_name;

grant drop any table to user_name;

grant select any table to user_name;

grant insert any table to user_name;

grant update any table to user_name;

grant create any procedure to user_name;
grant execute any procedure to user_name;

--drop user user_name;
--drop tablespace user_name_tb; 

create temporary tablespace dev_temp

tempfile '/data/phonedb/datafile/dev_temp.dbf'

size 50m

autoextend on

next 50m maxsize unlimited --  2048m

extent management local;

create tablespace dev_tb

logging

datafile '/data/phonedb/datafile/dev_tb.dbf'

size 32m

autoextend on

next 32m maxsize unlimited

extent management local

default compress;

create user user_name identified by "aaaaaa"
default tablespace DEV_TB
temporary tablespace DEV_TEMP;
-- Grant/Revoke role privileges
grant connect to user_name;
grant resource to user_name;
-- Grant/Revoke system privileges
grant create session to user_name;
grant select any table to user_name;

grant unlimited tablespace to dev;

alter user user_name default tablespace dev_tb;

alter user user_name temporary tablespace  dev_temp;

select * from dba_data_files

order by tablespace_name, file_name; 

alter user 用户名identified by 密码;