摘要：
select * from ((select gl_detail.explanation, bd_accsubj.dispname, gl_detail.debitamount 借方, gl_detail.creditamount 贷方, gl_detail.yearv, gl_detail.periodv , gl_voucher.no 凭证号, wmsys.wm_concat(gl_freevalue.valuecode) valuecode, wmsys.wm_concat(gl... 阅读全文
摘要：
来自itpub http://space.itpub.net/519536/viewspace-608769【故障现象】同事反映往日正常操作的数据库，现无法连接，错误提示：ORA-28000: the account is lockedsys@ora10g> conn sec/asdfasdfERROR:ORA-28000: the account is locked【故障处理】本着遇到问题处理问题优先的态度，先解决问题，处理的方法是：手工对用户进行解锁sys@ora10g> alter user sec account unlock;User altered.OK，到此，同事的日 阅读全文