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’;