-
编辑 删除
ORA-1555 with unrealistic Query Duration
Example in alert.log: Tue Oct 12 08:14:18 2010 ORA-01555 caused by SQL statement below (SQL ID: f8ry9dcxgdr6z, Query Duration=1286871258 sec, SCN: 0x0000.06a688b7): Tue Oct 12 08:14:18 2010 select... ...
-
编辑 删除
Interactions with PL/SQL(2) How to read multiple lines from the text file using PL/SQL
读取TXT文件并显示......[@more@]declare f utl_file.file_type; s varchar2(200);begin f := utl_file.fopen('e:test','sample.txt','R'); loop utl_file.get_line(f,s); dbms_output.put_line(s); end loop;exception when NO_DATA_FOUND then utl_file.fclose(f);end;
-
编辑 删除
在oracle系统中普遍存在的十大错误
Top Ten Mistakes Found in Oracle SystemsThis section lists the most common mistakes found in Oracle systems. By following Oracle's performance improvement methodology, you should be able to avoid thes...
-
编辑 删除
遭遇600-[qmxiUnpPacked2]
今天在删除一用户时系统报600错误:ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []打开trc文件一片茫然,经过查找得到关于此错误的一些信息:ORA-600 [qmxiUnpPacked2] ...
-
编辑 删除
OS block size
windows:C:\Documents and Settings\Administrator>fsutil fsinfo ntfsinfo c:NTFS Volume Serial Number : 0x343439fc3439c1a2Version :  ...
-
编辑 删除
Deterministic function
当用户在FBI中使用自定义函数时须加关键字:deterministic,就是说必须使用deterministic function……SQL> create table test as select * from all_objects;Table created.SQL> create or replace function f_lower(...
-
编辑 删除
Spfile&pfile
server parameter file (SPFILE)是oracle9i引入的新的参数机制,可以在线修改系统参数(on disk);1.启动 在默认情况下,oracle在以下路径按照顺序搜寻相应的参数文件 Path unix:$ORACLE_HOME/dbs w...
-
编辑 删除
ORA-01743: only pure functions can be indexed
SQL> create table test(c1 int,c2 varchar2(10));Table created.SQL> create index test_idx_01 on test(to_date(c2,'YYMMDD'));create index test_idx_01 on test(to_date(c2,'YYMMDD'))  ...
-
编辑 删除
My batchjob
嘿嘿......@echo offnet use 10.*.*.* "release" /user:"release"net use 10.*.*.* "db2user" /user:"db2"net use 10.*.*.* "dev2007" /user:"dev"explorer.....
-
编辑 删除
Convert long to char
将Long type data 转化为char type......sql>create table t1(c1 long);Table created.sql>insert into t1 values('aaaabbbcccc789');1 row created.sql>commit;Commit complete.sql>create table t2(c1 varchar2(30...
-
编辑 删除
Database limits(8i/9i)
Datatype/Physical Database/Logical Database/Schema Object Naming/Process / Runtime/ Limits ......Oracle 8.0.x and 8.1.x Database Limits Datatype Limits Datatypes Limit Com...
-
编辑 删除
An example of ref cursor(2)
An example of ref cursorSQL> create or replace function f_test return sys_refcursor is 2 v_cursor sys_refcursor; 3 begin 4 5 open v_cursor for 6 select * 7 from emp; 8 9 ret...
-
编辑 删除
flush shared pool and cache
1. shared pool alter system flush shared_pool;2. flush cache 8i: tablespace offline then online;9i: alter session set events 'immediate trace name flush_cache';10g: alter system flush buffer_cach...
-
编辑 删除
PL/SQL集合类型
在pl/sql中，有三种集合类型：index-by tables(associative arrays,9i之前plsql table),nested table,arrays,它们都可以作为装载集合数据的载体，但有以下区别：1. Nested table 和arrays 可以作为column,但index-by...
-
编辑 删除
Managing Partitioned Tables and Indexes
分区表及其索引......SQL> create table t_part(object_id int,object_name varchar2(30),create_date date ) 2 partition by range(create_date) 3 (partition p1 values less than(to_date('20010101','yyyym...
-
编辑 删除
有关ORA600错误的参数的解释文档
有关ORA600错误的参数的解释文档......Problem Description:==================== ORA-600 errors are internal exceptions handled by the RDBMS Kernel. They consist of multiple arguments, the ...
-
编辑 删除
Redhat as4下安装oracle817
结合多篇安装文档,在Redhat as4下安装oracle817版本跨度较大，但限于手头资源，只能如此了1. soft list compat-egcs-6.2-1.1.2.16.i386.rpm compat-egcs-c++-6.2-1.1.2.16.i386.rpm compat-egcs-objc-6.2-1.1.2.1...
-
编辑 删除
Oracle's x$ Tables(zz)
Oracle x$ "tables" are instance or session memory structures presented as tables and serve as base tables of most v$ views. Entries in the following list are added one at a time in the course of my st...
