使用ssh Secure file连接服务器上Oracle的时候。在SqlPlus工具上退格、上翻和下翻都会出现SQL> ^[[A的乱码解决办法:安装rlwrap下载地址:http://utopia.knoware.nl/%7Ehlub/uck/rlwrap/# tar zxvf rlwrap-0.37.tar.gz# cd rlwrap-0.37/# ./configure# make# make install首先确保Linux操作系统已经安装read...【阅读全文】
exp导出的时候出现ORA-01758错误。[oracle@htbbs ~]$ exp userid=yansp/test tables=test file=test.dmpExport: Release 11.2.0.3.0 - Production on Sat Jun 8 11:04:05 2013Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterpris...【阅读全文】
环境:DB:11.2.0.1本想对ddl做审计,执行如下语句报错误SQL> connect system/oracle@mydb已连接。SQL> AUDIT Drop ANY TABLE BY scott BY Session WHENEVER Successful;AUDIT Drop ANY TABLE BY scott BY Session WHENEVER Successful ...【阅读全文】