jlandzpa's Blog

--使用excel本身的功能,生成insert语句 , 比较简单.

http://space.itpub.net/32/viewspace-184153

保存以备用.

遇到一个link出错，参考以下博客后解决：

http://yangtingkun.itpub.net/

在安装过程中，报错误： Error in invoking target install of makefile /opt/oracle/product/9.2/rdbms/lib/ins_rdbms.mk ，这里也点击 ignore 忽略错误。

 查看全文

同事用dbca创建数据库的时候，运行到了输入 Global database name和sid的时候，
已经输入了，但是next的时候提示
the database name must be between 1 and 8 characters
the sid name must be between 1 and 8 alphanumic characters in length.

原因是：跟建库的终端程序有关。

解决方法：在本地即可.

贵州歌后阿幼朵---现在到处都在放她的歌曲 查看全文

解决ORA-01410:Invalid ROWID的一般步骤
===========================================================

1.使用ANALYZE TABLE <table> VALIDATE STRUCTURE CASCADE验证表和索引中的rowid是否有效.

2.设置event = "1410 trace name errorstack level 3" 跟踪,分析跟踪文件.
"

My suggestion:

1)do the above steps,

1)possibly the index of this table needs rebuild

2)data file corruption: use dbverify
Example
To verify the integrity of the data01.dbf data file, starting with block 1 and
ending with block 500, you execute the following command:
UNIX
$ dbv /users/DB00/u03/data01.dbf start=1 end=500

This should be similar to "analyze table"

Hope this is helpful.

ftp -i -n -s:ftpcommget.txt > ftp_r.txt

ftpcommget.txt：

open 192.168.2.191
user root passwd
get smit.log
close
bye

1) alter session set "_smu_debug_mode" = 4;
2) execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('XX.XX.XXXXXX');

p570 oracle9204 rbo

SQL> set autotrace traceonly;

select a.czrkrybh,a.czrkxm,b.czrkpcs from t_person a ,t_huji b

where a.czrkryid=b.czrkryid and a.czrkgmsfhm='510214197501131748';

Execution Plan

----------------------------------------------------------

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=48337 Card=274445 By

tes=20583375)

1 0 HASH JOIN (Cost=48337 Card=274445 Bytes=20583375)

2 1 TABLE ACCESS (BY INDEX ROWID) OF 'T_PERSON' (Cost=2 Card

=272416 Bytes=17707040)

3 2 INDEX (RANGE SCAN) OF 'IND_T_PERSON_CZRKGMSFHM' (NON-U

NIQUE) (Cost=1 Card=108966)

4 1 VIEW OF 'index$_join$_002' (Cost=34791 Card=39567074 Byt

es=395670740)

5 4 HASH JOIN (Cost=48337 Card=274445 Bytes=20583375)

6 5 INDEX (FAST FULL SCAN) OF 'IND_T_HUJI_CZRKRYID' (NON

-UNIQUE) (Cost=33 Card=39567074 Bytes=395670740)

7 5 INDEX (FAST FULL SCAN) OF 'IND_T_HUJI_PCS' (NON-UNIQ

UE) (Cost=33 Card=39567074 Bytes=395670740)

Statistics

----------------------------------------------------------

0 recursive calls

0 db block gets

177037 consistent gets

491176 physical reads

0 redo size

645 bytes sent via SQL*Net to client

655 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

1 rows processed

1.在oracle建好表

2.用excel打开xml文档,进行格式的修改

3.用toad导入表中

4.写过程将数据更新到相应的表中

www.sans.org/score/checklists/Oracle_Database_Checklist.pdf

一个不错的文档，保留一下地址:)

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

在执行DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY时报的错：

ORA-30019: 自动撤消模式中的回退段操作非法
ORA-06512: 在"SYS.DBMS_TRANSACTION", line 65
ORA-06512: 在"SYS.DBMS_TRANSACTION", line 85
ORA-06512: 在line 1

pending进程的状态的collecting，解决办法如下：

1.) alter session set "_smu_debug_mode" = 4;
2.) execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('......');

注意：如果有多条pending事务，每次要退出sqlplus，并重复以上操作.

一个统计数据库，
开发人员反应，程序运行过程中，遇到如下错误：
ORA-00600:[kafspa:columnBuffer1], [1859], [3], [], [], [], [], []

做数据库全库逻辑备份时，到某个表报如下错误：
EXP-00056: ORACLE error 3113 encountered

出现异常的表有几个,处理过程发现：

1.所有表用 create table aaa as select * from ,不报错.
2.异常数据： select * 出来的时候，则出错. 错误有：ORA-00600，ora-03113
3.异常数据中的一部分不能delete, 错误有：
ORA-08102: index key not found, obj# 6566, dba 113953069 (2)
ORA-00600: internal error code, arguments: [17182], [0x110315F70], [], [], [],
这些只能truncate了.

有些数据是number类型，但其lengthb却是40.

最后是通过一个存储过程，并结合手工处理掉所有的异常数据.

drop table jl_rowid;

create table jl_rowid (pk varchar2(20), err varchar2(100));

create or replace procedure jl
is
cursor jl_cursor
is select rowidtochar(rowid) from tablename where rownum < 100000;
ls_rowid varchar2(20);
ln_aaa number;
ls_sqlerrtext varchar2(100);
begin
open jl_cursor;
loop
fetch jl_cursor into ls_rowid;
if jl_cursor%notfound then
exit;
else
begin
insert into tablename_01 nologgin
select * from tablename where rowid = chartorowid(ls_rowid);
delete from tablename where rowid = chartorowid(ls_rowid);
commit;
exception when others then
rollback;
ls_sqlerrtext := substrb(sqlerrm,1,100);
insert into jl_rowid values(ls_rowid,ls_sqlerrtext);
commit;
end;
end if;
end loop;
close jl_cursor;
end;
/

sqlplus里执行某条语句，报错：

ORA-01114: 将块写入文件 %s 时出现 IO 错误 (块 # %s) 错误

文件号和块号没有报出来.:(

查看alert文件，后台却报出来了.