全部博文(535)
发布时间:2013-07-26 13:42:32
可通过 select userenv('language') from dual; 语句查看安装的字符集;如果不符合生产要求,请先修正字符集,方法如下 :oracle修改服务器端字符集:SQL>SHUTDOWN IMMEDIATE; SQL>STARTUP MOUNT; SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=.........【阅读全文】
发布时间:2013-04-15 17:28:46
ORACLE DELETE表后的恢复ORACLE—DELETE表后的恢复(一)连接到数据库:C:/Documents and Settings/Administrator>sqlplus system/sa@otSQL*Plus: Release 9.0.1.0.1 - Production on Wed May 13 19:13:53 2009(c) Copyright 2001 Oracle Corporation. All righ.........【阅读全文】