- 博客(12)
- 资源 (1)
- 收藏
- 关注
原创 User has no SELECT privilege on V$SESSION(执行计划相关)
开启执行计划的时候,提示如下信息;User has no SELECT privilege on V$SESSION
2014-08-25 22:52:20 4064 1
原创 SP2-0618
起因:在SCOTT@ orcl>set autotrace onSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report
2014-08-20 21:51:35 735
原创 Xlib: connection to ":0.0" refused by server
Oracle帐号执行DBCA或其他JAVA图形界面程序时,报错:
2014-08-10 21:10:31 639
原创 ORA-00257
laiziguanfangwORA-00257: archiver error. Connect internal only, until freed.Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon,
2014-08-10 11:38:28 685
转载 Oracle 树操作(select…start with…connect by…prior)
oracle树查询的最重要的就是select…start with…connect by…prior语法了。依托于该语法,我们可以将一个表形结构的以树的顺序列出来。在下面列述了oracle中树型查询的常用查询方式以及经常使用的与树查询相关的oracle特性函数等,在这里只涉及到一张表中的树查询方式而不涉及多表中的关联等。1、准备测试表和测试数据
2014-08-06 20:48:39 493
原创 047:QUESTION 228
Question:A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled
2014-08-05 22:56:14 379
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人