--创建表空间
Create tablespace BRANCH datafile 'D:\tablespace\BRANCH.dbf' size 500M autoextend on maxsize unlimited;
--查询YS所拥有的表空间
select distinct(tablespace_name) from dba_segments where owner='YS';
--删除用户
drop user ys cascade;
--删除表空间及表空间文件
drop tablespace ysspace including contents and datafiles;
--查询session
select sid,serial# from v$session where username='ys';
--删除session
alter system kill session '222,333' immediate;
--解锁用户
alter user ys account unlock;
--用户修改密码
alter user ys identified by ys;
--创建用户
CREATE USER test1 PROFILE "DEFAULT"
IDENTIFIED BY test1 DEFAULT TABLESPACE "EBPSPACE"
QUOTA UNLIMITED
ON "EBPSPACE"
ACCOUNT UNLOCK;
--授权
GRANT "CONNECT" TO test1;
Grant read,write on directory db_bak to test1;
GRANT "DBA" TO test1;
--表移动表空间
alter table table_name move tablespace tablespace_name;
--有索引的话必须重建索引
alter index index_name rebuild tablespace tablespace_name;
--查看锁表
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;