-
Title
Oracle issue with exchange partition and clob columns -
Description
A problem is coming to light with the EXCHANGE PARTITION option used by Live Reorg Online Switch.
A factor is if the table has CLOBs which are moved from out of row storage to in row storage.
Before the exchange the tables are ok, but once the exchange has taken place, Oracle is unable to return the table in bulk to a select statement.
Analyze table validate structure cascade says the table is ok.
Selecting individual rows is ok.
Export of the table fails.
Select * from the table fails.
The failure is that the Oracle Server process aborts with an ORA-07445 panic. This is reported by the client process as an ORA-03113 error, because the client has lost contact with its server process.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.