Oracle建立表空间和用户

Oracle建立表空间和用户

1.建立表空间

例子：

--创建表空间

create tablespace  pub_svc  
datafile 'E:/oracle/tablespaces/pub_svc.dbf'   
size 500M   
autoextend on next 5M maxsize 3000M;

--删除表空间

drop tablespace pub_svc  including contents and datafiles 

2.建用户

--创建用户

create user 用户名 identified by 密码
default tablespace 表空间;  

--赋权限

grant connect,resource to pub_svc;  
grant create any sequence to pub_svc;  
grant create any table to pub_svc;  
grant delete any table to pub_svc;  
grant insert any table to pub_svc;  
grant select any table to pub_svc;  
grant unlimited tablespace to pub_svc;  
grant execute any procedure to pub_svc;  
grant update any table to pub_svc;  
grant create any view to pub_svc; 

--导入导出命令     
ip导出方式： exp demo/demo@127.0.0.1:1521/orcl file=f:/f.dmp full=y  
exp demo/demo@orcl file=f:/f.dmp full=y  
imp demo/demo@orcl file=f:/f.dmp full=y ignore=y