--当前户的权限
SELECT * FROM user_sys_privs;
--查看表
SELECT * FROM user_tables;
-- 查看主键
SELECT * FROM user_indexes;
--查看视图
SELECT * FROM user_views;
--查询视图是否可以更新
SELECT * FROM user_updatable_columns WHERE table_name = 'V_BUSER';
--视图状态
SELECT * FROM user_objects;
SELECT last_ddl_time, object_name, status FROM user_objects WHERE object_name = 'V_BUSER';
--所有序列
SELECT * FROM all_sequences;
--当前用户序列
SELECT * FROM user_sequences;
--数据库所有序列
SELECT * FROM dba_sequences;
--所有同义词
SELECT * FROM all_synonyms;
--用户同义词
SELECT * FROM user_synonyms;
--数据库同义词
SELECT * FROM dba_synonyms;
--查询ROWID信息
SELECT DBMS_ROWID.rowid_object ('AAAR/UAAFAAAAClAAB') object_id, -- 对象编号
DBMS_ROWID.rowid_relative_fno ('AAAR/UAAFAAAAClAAB') file_id, --数据文件编号
DBMS_ROWID.rowid_block_number ('AAAR/UAAFAAAAClAAB') block_id, --数据文件编号
DBMS_ROWID.rowid_row_number ('AAAR/UAAFAAAAClAAB') num --数据文件编号
FROM dual
WHERE ROWNUM < 5;
--查询进程,杀进程
SELECT sid, serial#, username, osuser FROM v$session where sid in(select session_id from v$locked_object);
--kill掉相关的会话
ALTER SYSTEM KILL SESSION '597,1171';
--重新执行rename命令成功!
07-14
2314
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountBlack.png)
08-19
1973
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountBlack.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交