My Oracle Support Banner

Schema Creator Utility Generates Error And Warning For Post Sql Scripts (Doc ID 2815018.1)

Last updated on OCTOBER 22, 2021

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

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

ERROR2: DECLARE
ERROR at line 1:
ORA-01430: column being added already exists in table
ORA-06512: at line 8

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.