![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
Esengnet
这个作者很懒,什么都没留下…
展开
-
database link
drop database link testdb_DBLINK/create database link testdb_DBLINK connect to user identified by password USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.原创 2015-03-23 14:58:50 · 389 阅读 · 0 评论 -
exp and imp usaged
1. export data from db exp developer/welcome@david file=d:\exp.dmp exp PRPCAPPD1/welcome@aa file=d:\PRPCAPPD1.dmp owner=PRPCAPPD1 log=d:\PRPCAPPD1.log exp SPRAPPD1/welcome@aafile=d:原创 2015-03-23 15:01:54 · 483 阅读 · 0 评论 -
ORACLE日期时间函数大全
ORACLE日期时间函数大全 TO_DATE格式(以时间:2007-11-02 13:45:25为例) Year: yy two digits 两位年 显示值:07 yyy three digits 三位年 显示值:007 yyyy原创 2015-03-23 14:56:36 · 564 阅读 · 0 评论 -
find out deadlock processid and kill it
select t2.username,t2.sid,t2.serial#,t2.logon_timefrom v$locked_object t1,v$session t2where t1.session_id=t2.sid order by t2.logon_time;alter system kill session '547,6096' immediate;原创 2015-03-23 15:02:45 · 494 阅读 · 0 评论