My Oracle Support Banner

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

Last updated on FEBRUARY 08, 2019

Applies to:

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


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.


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

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