Oracle数据库初始化简单操作

1. initialize oracle tablespace 初始化oracle数据库表空间

create tablespace test  
datafile 'c:\oracle\test.dbf' size 50M  
default storage (initial 500K   
Next 500K  
minextents 1  
maxextents unlimited  
pctincrease 0); 

2. create user 创建用户

create user username identified by password default tablespace test;

3. grant priviage to user 赋予用户权限

grant resource,connect,dba to test; 

4. deleta tablespace 删除表空间

drop tablespace "tablespacename" including contents and datafiles 

5. delete user 删除用户

drop user "username" cascade 

6. add extra space to tablespace 增加表空间

alter tablespace chinawater add datafile 'c:\oracle\oradata\orcl9\ADDCHINAWATER.dbf' size 200M 

7. 给用户授权 授予DBA权限

grant dba to test;

8. 授予不限制的表空间

grant unlimited tablespace to test;

9. 授予查询任何表

grant select any table to test;

10. 授予 查询 任何字典

grant select any dictionary to test;