oracle创建用户语句

create tablespace test
logging
datafile 'E:\oracle\product\10.2.0\oradata\test.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

 

create temporary tablespace test_temp  

tempfile 'E:\oracle\product\10.2.0\oradata\test_temp.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;

 

create user test identified by test default tablespace test temporary tablespace test_temp; 


grant connect,resource to test;

 

 

--创建表空间

create tablespace kanban

datafile '/u02/oradata/func44/kanban.dbf' 

size 50m 

autoextend on 

next 50m 

extent management local; 

 

--创建临时表空间

create temporary tablespace kanbantemp  

tempfile '/u02/oradata/func44/kanbantemp.dbf' 

size 50m  

autoextend on  

next 50m   

extent management local;

 

--创建用户

create user kanban identified by kanban default tablespace kanban temporary tablespace kanbantemp;