oracle创建表空间及用户

create temporary tablespace user1_temp

tempfile 'H:\oradata\orcl\user1_temp.dbf'   //oracle的安装路径已经物理文件生成路径

size 1000m

autoextend on

next 100m maxsize 2000m

extent management local;

 

create tablespace user1_data

datafile 'H:\oradata\orcl\user1_data.dbf'  //oracle的安装路径已经物理文件生成路径

size 1000m

autoextend on

next 100m maxsize 2000m

extent management local;

 

 

create user user1 identified by yc  //创建用户user1，密码是yc

default tablespace user1_data

temporary tablespace user1_temp;

 

grant connect,resource to user1;

 

revoke unlimited tablespace from user1;

 

alter user user1quota unlimited on user1_data;

 

grant imp_full_database to user1;

 

grant exp_full_database to user1;

 

alter user user1temporary tablespace user1_temp;

 

再上面的命令中,其中建了一个user1的账户,并且建立了两个物理文件.

执行完上面的命令之后就可以对此用户进行操作了