Sqlldr Drop.sql And Create.sql Generated Scripts Do Not Match Project Create-index.sql Script (Doc ID 2091403.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Master Person Index - Version 3.0 and later
Information in this document applies to any platform.

Goal


The SQL*Loader (sqlldr) drop.sql and create.sql generated scripts do not match project create-index.sql script.

When the sqlldr scripts are generated there are both a drop.sql and a create.sql script that are created. The drop.sql is intended to drop all indexes on the object tables and disable all of the constraints to allow for the sqlldr script to bulk load the data into the database. The create.sql script is intended to add all of the indexes back to the database and to re-enable the db constraints.

The problem is that the generated scripts do not even come close to including the same set of indexes as were originally created by the create-index.sql script included with the project.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms