Inserting Access data into an Oracle table with indices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Insert Record into Oracle Table 1
INSERT INTO where data is on an Oracle database 3
insert rows from table into existing table 2
'Overflow' message when query executes 2
Using Append Queries with Linked Tables 3
insert into a table 1
How to export table from outlook into ms access table? 0

Back
Top