Troubleshooting
Problem
Error ORA-01455 is seen within Optim products against Oracle 11.2 and later.
Symptom
The following examples have been seen with this underlying problem:
- After installing Optim for Oracle eBusiness 6.0 connected to an Oracle 11.2 database, importing the templates for module AR and OM may fail with the following error message:
primary key on:
apps_optim_candidate
"Unable To Import Primary Key.
R12ARC.APPS.OPTIM_CANDIDATES
ORA-01455 converting collumn overflows integer datatype"
The template import fails. - The following error can be seen when attempting to restore a table from archive:
Internal error: ORA-01455: overflow of integer type on conversion of column (7500)
Cause
This error is related to the new Oracle 11gR2 database feature called "Deferred Segment Creation" and the fact that empty tables are not listed in dba_segments. Optim 7.3.1 and earlier releases support Oracle 11.2 DB in toleration mode only. This means new features introduced in 11.2 are not supported.
Resolving The Problem
This database feature is controlled by the database parameter "deferred_segment_creation". It has default value of TRUE. Set it to "FALSE" and any newly created tables after the change will be exported correctly. The following sql can be used to set this parameter:
- ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=false ;
Alternatively you can use the following command to force extent allocation for a specific table:
- ALTER TABLE <empty table name> ALLOCATE EXTENT;
Full support of Oracle 11.2 DB is available in version 8.1.
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg21506554