Oracle&PL/SQL
浪菜叶
数据仓库实践者
展开
-
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Cause:The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically register原创 2010-06-18 10:53:00 · 1586 阅读 · 0 评论 -
记录被另一个用户锁
<br />1. 查询被锁进程:<br />SELECT A.OWNER, <br /> A.OBJECT_NAME, <br /> B.XIDUSN, <br /> B.XIDSLOT, <br /> B.XIDSQN, <br /> B.SESSION_ID,原创 2011-01-18 15:21:00 · 411 阅读 · 0 评论