oracle10g 常用命令

来源：互联网发布：win10 telnet 端口23 编辑：程序博客网时间：2024/05/19 16:37

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