ORA-07445 error deleting 5 rows from XMLtype table

I have a 9.0.1 instance running on Solaris 2.6. I created a table

purchaseorder

          podocument sys.xmltype

I inserted 5 rows (each row is about 150 bytes... small) and later attempted to delete the rows with

delete from purchaseorder;

I get ORA-03113: end-of-file on communication channel in sqlplus and

Errors in file /dev_tools/oracle/product/oradata/TSTDB/dump/tstdb_ora_5990.trc: ORA-07445: exception encountered: core dump [kdugetpart()+156] [SIGSEGV] [Addres
s not mapped to object] [0x7C62] [] []

In the alert log.

The trc file has a bunch of nothing, the only part that looked useful is

• 2001-11-02 14:57:59.394
• SESSION ID:(9.1484) 2001-11-02 14:57:59.386 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7c62, PC: [0xb26d40, kdugetpart()+156]
• 2001-11-02 14:57:59.430 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kdugetpart()+156] [SIGSEGV] [Addres s not mapped to object] [0x7C62] [] [] Current SQL statement for this session: delete from purchaseorder

Does anyone have an idea what this might be? I can delete one row, I can truncate the table, but I can't delete all 5. Has anyone seen this for XMLtype or for tables with CLOB columns?

Thanks

Carl

cmercer_at_vibrant-1.com Received on Fri Nov 02 2001 - 14:19:09 CST