D
Dale Fye
I am using ACCESS 2002, and am trying to insert a large amount of data from
Access into an Oracle table which has composite PK, several indices, and a
couple of constraints (Non-NULL fields). I have been advised that I should
drop the indices before the insertion, insert the data, then reindex the
table.
I got some code from a co-worker which disables/enables all of the
constraints on a particular table. Will disabling and enabling these
constraints accomplish the same thing as dropping the indexes from the table,
then adding them after the insert.
Access into an Oracle table which has composite PK, several indices, and a
couple of constraints (Non-NULL fields). I have been advised that I should
drop the indices before the insertion, insert the data, then reindex the
table.
I got some code from a co-worker which disables/enables all of the
constraints on a particular table. Will disabling and enabling these
constraints accomplish the same thing as dropping the indexes from the table,
then adding them after the insert.