|
dbms_lob.copy + ORA-00600 [25027], [4]
#39261064
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
Добрый день!
Столкнулся с такой проблемой: При выполнении
1.
2.
3.
4.
5.
6.
7.
8.
9.
declare
l_request_out clob;
l_request_in clob;
begin
select request_xml into l_request_out from request_log where id_request_log = 71886;
update request_log set request_xml = empty_clob() where id_request_log = 71868;
select request_xml into l_request_in from request_log where id_request_log = 71868;
dbms_lob.copy(dest_lob => l_request_in, src_lob => l_request_out, amount => dbms_lob.getlength(l_request_out));
end;
выскакивает ошибка:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
</msg>
<msg time='2016-06-23T14:02:06.664+03:00' org_id='oracle' comp_id='rdbms'
msg_id='1555644195' type='INCIDENT_ERROR' group='Generic Internal Error'
level='1' host_id='rc83-fb-gk530000stdb' host_addr='10.5.28.104'
prob_key='ORA 600 [25027]' upstream_comp='' downstream_comp=''
ecid='' errid='877012' detail_path='/app/oracle/diag/rdbms/rcdb/rcdb/trace/rcdb_ora_16221.trc'>
<txt>Errors in file /app/oracle/diag/rdbms/rcdb/rcdb/trace/rcdb_ora_16221.trc (incident=877012):
ORA-00600: код внутренней ошибки, аргументы: [25027], [4], [12846991], [], [], [], [], [], [], [], [], []
</txt>
</msg>
/app/oracle/diag/rdbms/rcdb/rcdb/trace/rcdb_ora_16221.trc:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
Trace file /app/oracle/diag/rdbms/rcdb/rcdb/trace/rcdb_ora_16221.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.2.0/db_1_x64
System name: Linux
Node name: db
Release: 2.6.32-573.1.1.el6.x86_64
Version: #1 SMP Sat Jul 25 17:05:50 UTC 2015
Machine: x86_64
VM name: VMWare Version: 6
Instance name: rcdb
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 16221, image: oracle@db
*** 2016-06-23 14:02:06.668
*** SESSION ID:(1733.21457) 2016-06-23 14:02:06.668
*** CLIENT ID:() 2016-06-23 14:02:06.668
*** SERVICE NAME:(SYS$USERS) 2016-06-23 14:02:06.668
*** MODULE NAME:(PL/SQL Developer) 2016-06-23 14:02:06.668
*** ACTION NAME:(SQL Window - test.sql) 2016-06-23 14:02:06.668
DDE: Problem Key 'ORA 600 [25027]' was flood controlled (0x4) (incident: 877012)
ORA-00600: код внутренней ошибки, аргументы: [25027], [4], [12846991], [], [], [], [], [], [], [], [], []
На новой таблице - ошибки нет. На пустой - тоже нет.
Кто может подсказать в чем причина и куда копать? |
|
|
