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

Last updated on MAY 22, 2023

Applies to:

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

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