Oracle Create User

--Look up the name and size of the table space
SELECT T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) ts_size from Dba_tablespaces T, dba_data_files D WHERE t.ta Blespace_name = D.tablespace_name GROUP by t.tablespace_name;
--Find the physical name of the table space
SELECT Tablespace_name, 
FILE_ID, 
file_name, 
Round (Bytes/(1024* 1024x768), 0) Total_space 
From Dba_data_files 
ORDER Bytablespace_name; 
--Create a temporary table space
Create temporary tablespace xxx_temp
Tepmfile ' temporary table Space storage path \XXX_TEMP.DBF '
Size 50m--Specify the initial value size
Autoextend on next 50m--50m self-increment after exceeding 50m
MaxSize 20480m extent management local;
--Create TABLE space
Create Tablespace Xxx_data
Logging
DataFile ' table Space storage path \XXX_DATA.DBF '
Size 50m
MaxSize 20480--Specify maximum value
Extent management Local;
--Create user and specify Tablespace
Create user xxx identified by Xxxxs
Default tablespace xxx_data--specifies a table space
Temporary tablespace xxx_temp;--z specifying a temporary table space
--grant permissions to the created user
Grant connect,resource,dba to XXX;

　　

Oracle Create User