Basis and others: 692745 - Termination of table online reorganization with ORA-31600

Symptom

During an online tablespace reorganization of a large number of tables (more than 9999) with brspace (see note 646681), the following error occurs sporadically, that is, only with some tables:
BR1124I Starting reorganization of table <table_name> ...
BR0280I BRSPACE time stamp: 2003-12-12 16.45.59
BR0301E SQL error -31600 at location ddl_tab_create-33
ORA-31600: invalid input value 100000001 for parameter HANDLE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1207
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3641
ORA-06512: at "SYS.DBMS_METADATA", line 670
ORA-06512: at "SYS.DBMS_METADATA", line 583
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-06512: at line 1
BR0280I BRSPACE time stamp: 2003-12-12 16.45.59
BR1119E Creating DDL statements for <table_name> failed
BR0280I BRSPACE time stamp: 2003-12-12 16.45.59
BR1106E Reorganization of table <table_name> failed
BR1111I Reorganization of table <table_name> will be skipped
As result, this table is not reorganized (it is not changed). In general, only a relatively small number of tables are affected.

Other Terms

Reason and Prerequisites

This problem is caused by an Oracle error in the DBMS_METADATA package (see Oracle Bug3138734) in Oracle 9.2.0. The error is corrected as of Oracle Patchset 9.2.0.5.

Solution

Repeat the reorganization of the tables that were skipped because of this error. Since only a small number of tables now have to be reorganized, this error should no longer occur.

Other Attributes

Database System

ORACLE

Header Data


Released On	19.12.2003 13:22:04
Release Status	Released for Customer
Component	BC-DB-ORA Oracle
Priority	Correction with medium priority
Category	External error