Schema Creator Utility Generates Error And Warning For Post Sql Scripts
(Doc ID 2815018.1)
Last updated on MAY 22, 2023
Applies to:Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.
On BD 8.1.1
Problem Description: We are doing a fresh installation of BD 8.1.1 and trying to execute schema creation utility in OFFLINE mode with Silent option with below steps.We could see few errors and warning, when generated sql script is executed by DBA.
Steps to Reproduce:
1. Navigate to OFS_BD_PACK/schema_creator/conf and edit OFS_BD_SCHEMA_IN.xml file
2. Execute the osc.sh file using the following command: ./osc.sh -o -s
3. On successful execution of schema creator utility, the console displays the following status message:Success. Execute OFS_BD_PACK/schema_creator/sysdba_output_scripts.sql before proceeding with the installation.
4. Login to SQLPLUS with a user having SYSDBA Privileges and execute the sysdba_output_scripts.sql and it generates sysdba_output_scripts.log
ERROR1: CREATE UNIQUE INDEX AAI_OBJECT_TAG_PK ON AAI_OBJECT_TAG
ERROR at line 1: ORA-01450: maximum key length (6398) exceeded
ERROR at line 1:
ORA-01430: column being added already exists in table
ORA-06512: at line 8
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document