![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ORACEL DB
渺渺路人
你好
展开
-
Create BD link
create database link hr_db connect to hrprod identified by "123456" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.)(PORT = 1000)) ) (CONNECT_DATA = (SERVICE_NAME = devdb) ) )';...原创 2021-12-23 10:36:02 · 1066 阅读 · 0 评论 -
查询正执行的procedure的session
SELECT 'alter system kill session '''||s.sid||','||s.serial#||''';',s.* FROM dba_ddl_locks a,v$session swhere a.name = upper('p_procedurename') and a.session_id = s.SID;alter system kill session '17,2315';原创 2021-12-23 10:31:45 · 486 阅读 · 0 评论 -
查询删除的数据
select * from ap_invoices_all as of timestamp to_timestamp('2014-08-20 12:20:00','yyyy-mm-dd hh24:mi:ss');原创 2021-12-23 09:24:09 · 270 阅读 · 0 评论 -
物化视图更新
exec DBMS_MVIEW.REFRESH('V_VIEWNAME');原创 2021-12-23 09:22:01 · 257 阅读 · 0 评论