===== Alter Table modify mit ANYDATA Datentyp => ORA-00600: internal error code, arguments: [kqludp2] =====

\\
Datenbank Version 10.2.0.4 auf Win64\\

Befehl:

<code>
alter table APP_RESULTS modify ( MARKETING_TEXT VARCHAR2(2000))
</code>
führt zu:
\\
Tace aus dem Alert-Log:
<code>
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))
</code>

Lösung:  Definition der Tabelle muss mit Upgrade aktualisert werden
<code>
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

</code>


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