oracle 10g常用命令,oracle10g 常用命令

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