-
编辑 删除
exec(): 0509-036 Cannot load program onstat because of the following errors
在sqlplus username/passwd时遇到以下错误：exec(): 0509-036 Cannot load program onstat because of the following errors: 0509-130 Symbol resolution failed for /usr/lib/threads/libc.a[aio_64.o]beca...
-
编辑 删除
ORA-12704: character set mismatch
在utf8数据库里编译存储过程，遇到这个问题.oracle9206sql: [做了简化]select a from t1union allselect '1' from t2;其中t1.a是nvarchar2类型。解决办法很简单:select a from t1union allselect N'1' from t2;...
-
编辑 删除
How to select the one column per row in display?
从网上找到的一个脚本,自己改了改.create or replace procedure print_table(qry in varchar2)asq_cursor integer; column_val &nbs...
-
编辑 删除
ORA-00600 [qctstc2o1]
from metalink;Note: For additional ORA-600 related information please read Note 146580.1PURPOSE: This article discusses the internal error "ORA-600 [qctstc2o1]", what it means and possible...
-
编辑 删除
Logon DB Trigger to Setup the User Environment[akadia]
Date and time format settings are based on the user's locale and native language. For example, SCOTT needs default NLS_DATE_FORMAT "MM/DD/YYYY", and ZAHN needs default "DD-MON-YYYY".,etc. The idea is ...
-
编辑 删除
一个查看oracle最新漏洞的网址
http://www.oracle.com/technology//deploy/security/alerts.htm
-
编辑 删除
一个分布式查询的优化
表a: oracle9204 本地库，数据不多 rbo表b: oracle9204 远程库，220万 rbo表c: oracle9204 远程库，220万 rboselect ....... from a,b@dblink,c@dblinkwhere a.id=b.id and a.id=c.id;查询时间是;65s,无法满...
-
编辑 删除
问题解决小记[20040820]：应用程序系统频繁报错 ora-03115
aix433 oracle8.1.7.0 64位应用程序正常运行了3年，近期突然频繁报ora-03115，简单的查询也会出错.而应用程序程序有所改动，但开发人员认为不会是改动原因。ORA-03115: unsupported network datatype经查metalink,原...
-
编辑 删除
Logging of DML commands[akadia]
Action LoggingSuppose you are asked about certain activities on your database, in this example on a certain table. You need to keep track who has inserted, updated, or even deleted which record in thi...
-
编辑 删除
这个春节
一半时间给了家人,一半时间给了"汉武大帝".64集的"汉武大帝",拍得确实很大气,紧张刺激,看得比较过隐.
-
编辑 删除
ora-03232:unable allocate and extent of 9 blocks from tablespace 9
tablespace 9是个临时表空间，12G，几乎是没有用的.oracle8.1.7.4 for HP遇到大的查询就会报错.将临时表空间建成字典类型的就解决了，看样子又是一个BUG。
-
编辑 删除
Online Rebuild of Indexes[adakia]
If you must create an index on a large and busy table which cannot suffer any downtime, then you can build this index without interrupting the availability of this table.The command ...CREATE INDEX in...
-
编辑 删除
Oracle8i Profiler for PL/SQL[akadia]
Profilers are helpful tools to investigate programs and identify slow program parts and bottle necks. Furthermore you can determine which procedure, function or any other code part is executed how man...
-
编辑 删除
DIGITAL: ORA-7307 or ORA-9857 Trying to Increase SGA
from metalink:TIP: Click help for a detailed explanation of this page. Bookmark Go to EndSubject: DIGITAL: ORA-7307 or ORA-9857 Trying to Increase SGA Doc ID: Note:1023998.6 Type: PROBLEM Last Re...
-
编辑 删除
尽量使用oracle自身的功能
tom在新书阐述了以上观点. 对于开发者来说，绝对不能将oracle简单地看成一个存储数据的黑匣子，应该深入了解oracle所提高的各项功能.任何想证明比oracle聪明的做法大都是徒劳的...
-
编辑 删除
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], [
when I tried to create a view in a non-existant schema(oracle 9.2.0.4 for )CREATE OR REPLACE VIEW non_existant.New_view_name as....System name: HP-UX rac 9.2.0.4
-
编辑 删除
老外的一份简历
写英文简历时也许会用的着:)INDUSTRY EXPERIENCE HELD : Banking ( Mauritius Commercial Bank), Finance ( DCDMC, Representing Andersen Worldwide ), Telecom ( British Telecom), Shipping ( P & O ...
-
编辑 删除
Automatically Calculating Percentages in Queries[akadia]
Starting with Release 7.1 of Oracle, users have had access to a feature called an inline view. An inline view is a view within a query. Using this feature, you can easily accomplish your task.Example:...
-
编辑 删除
忆吴大江的一件事
这件事情是我的同事在大约两年前告诉我的,当时我还在公司的软件部门,后来我的同事去了oracle,现在也已经成了资深工程师了.再后来我也转到售后部门了. 当时我们公司维护的一个...
-
编辑 删除
ora-12545 错误解决一例
在win2000 上用sqlplus远程登陆一台alpha机器时抱错:ora-12545连接因对象主机或对象不存在而失败经检查ping和tnsping都没有其他.解决办法： 在 c:winntsystem32driversetchosts文件添加alpha机器的ip地址和hostname*...
