dba:oracle_ora_600_kqludp2
Alter Table modify mit ANYDATA Datentyp => ORA-00600: internal error code, arguments: [kqludp2]
Datenbank Version 10.2.0.4 auf Win64
Befehl:
alter table APP_RESULTS modify ( MARKETING_TEXT VARCHAR2(2000))
führt zu:
Tace aus dem Alert-Log:
ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kqludp2], [0x2D3257B40], [2], [], [], [], [], [] Current SQL statement for this session: alter table APP_RESULTS modify ( MARKETING_TEXT VARCHAR2(2000))
Lösung: Definition der Tabelle muss mit Upgrade aktualisert werden
SET echo off SET feedback off SET term off SET pagesize 0 SET linesize 80 SET newpage 0 SET space 0 spool c:\upgrd.SQL SELECT DISTINCT 'alter table '||owner||'.'||table_name||' upgrade;' FROM DBA_TAB_COLUMNS b WHERE DATA_TYPE='ANYDATASET'; spool OFF spool c:\upgradeinfo.log @@c:\upgrd.sql spool off
Auszug aus der Doku:
⇒ http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_3001.htm#i2125849
…
The upgrade_table_clause is relevant for object tables and for relational tables with object columns. It lets you instruct Oracle Database to convert the metadata of the target table to conform with the latest version of each referenced type. If table is already valid, then the table metadata remains unchanged.
…
Quellen
- Artikel zu ANYDATA ⇒ http://www.orafaq.com/node/1853
- Artikel zu ANYDATA ⇒ http://www.oracle-developer.net/display.php?id=218
- Artikel zu ANYDATA ⇒ http://www.oracle-base.com/articles/misc/anydata.php
dba/oracle_ora_600_kqludp2.txt · Zuletzt geändert: 2014/02/21 12:43 von gpipperr