Oracle数据库创建用户、表空间、赋权限、查询锁死表

create tablespace CLOUD_SCFS_DEV 
    datafile '/home/oracle/oracle/product/10.2.0/oradata/orcl/SEC1_XDYQ_SCFS_DEV.dbf'
    size 200M reuse autoextend on next 16K maxsize unlimited extent management local         autoallocate;

create user SEC1_XDYQ_SCFS_DEV
     identified by "SEC1_XDYQ_SCFS_DEV"
      default tablespace CLOUD_SCFS_DEV
      temporary tablespace TEMP
      profile DEFAULT;

grant create user,drop user,alter user,create any view,
        select any table,delete any table,
        insert any table,update any table,
        drop any view ,exp_full_database,imp_full_database,
        connect,resource,create session to SEC1_XDYQ_SCFS_DEV;
grant create database link to SEC1_ANPING_LEASE_DEV;
----------------
级联删除
drop user SEC1_XDYQ_SCFS_DEV cascade;
drop tablespace SEC1_XDYQ_SCFS_DEV ;
----------------
创建DB_LINK
1、给你们用户授予DBA权限
2、执行sql
3、取消你们用户的DBA权限
:
-- Create database link 
create database link EBSAPPS.REGRESS.RDBMS.DEV.US.ORACLE.COM
  connect to FACTORING identified by FACTORING
  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.118.144)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

----------------------
删除Oracle会话
select * from v$session;
:
alter system kill session 'sid,serial#';
:
第一个是查询v$session视图找到需要被kill掉的会话
:
通过记录中sid,serial#两个字段的值kill会话

alter system kill session '970,46902'
---查询锁死表SESSION
SELECT  a.object_id, a.session_id, b.object_name, c.*   

　　　　FROM  v$locked_object a, dba_objects b, v$session c  

　　　　WHERE  a.object_id = b.object_id  

　　　　AND  a.SESSION_ID = c.sid(+)