oracle10g 常用命令

1、linux下创建临时表空间

create temporary tablespace weblogic_tmp   

tempfile '/opt/oracle/oradata/orcl/weblogictmp.dbf'   
size 1024m   
autoextend on   
next 200m maxsize 2048m   

extent management local;

2、创建表空间

    create tablespace weblogic   
    logging   
    datafile '/opt/oracle/oradata/orcl/weblogic.dbf'   
    size 1024m   
    autoextend on   
    next 200m maxsize 2048m   
    extent management local;  
3、删除表空间
drop tablespace weblogic including contents and datafiles;
4、常见用户并关联表空间
create user weblogic identified by weblogic  
default tablespace weblogic  
temporary tablespace weblogic_tmp;  
5、删除用户及相关数据

drop user weblogic cascade;

6、授权

grant sysdba to weblogic;
grant sysdba to weblogic;
grant connect,resource,select to weblogic;
grant dba to weblogic;

grant create session to weblogic; 

7、收回授权

-revoke all  from weblogic;

8、查询所有表空间

select tablespace_name from dba_tablespaces;

9、查看用户和对应的表空间

select username,default_tablespace from dba_users;

10、查看用户权限

select privilege from dba_SYS_privs where grantee='DEV_IPM';