--当前户的权限
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命令成功!
--查看外键的级联信息
SELECT * FROM user_constraints;
Oracle常用视图或表(补充中)
最新推荐文章于 2024-01-18 14:21:12 发布