06 2014 档案
摘要:17:46:15 HR@ datacenter>set autotrace onlyUsage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]17:47:36 HR@ datacenter>set autot ...
阅读全文
摘要:Execution Plan----------------------------------------------------------ERROR:ORA-01039: insufficient privileges on underlying objects of the viewSP2-...
阅读全文
摘要:比如直接查看ORA-01031错误gaosheng-> oerr ora 0103101031, 00000, "insufficient privileges"// *Cause: An attempt was made to change the current username or pass...
阅读全文
摘要:1、先停监听日志lsnrctl set log_status off;2、删除日志(11g监听日志路径)/u01/app/oracle/diag/tnslsnr/“实例名”/listener/alert/u01/app/oracle/diag/tnslsnr/“实例名” /listener/trac...
阅读全文
摘要:1、创建普通表create table p_temp(id number,init_date date);2、往普通表中插入数据set serveroutput ondeclare init_date date := to_date('2014-01-01 00:00:00','YYYY-MM...
阅读全文
摘要:参考地址
阅读全文