Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jul 31 00:02:18 CDT 2012
Sounds like it was the transaction file that was taking the time - storing the info needed to roll back the insert if required. Did you explicitly wrap the insert in a single transaction? I suspect not. -- Stuart On 31 Jul 2012 at 4:32, Benson, William (GE Global Research, consu[AccessD] Strange append query execution Access t wrote: > I have an accdb which in which oracle tables are linked using odbc. I > was inserting into one of the oracle tables all the records from a > local Access table. The query was taking a very long time, for under > 10K records, about 10 columns. Strange thing was, I checked the oracle > table using SQL Developer early on in the process and it seemed like > the data was there lickety-split. I saw the full record count, and did > check the actual data, which looked fine. Not sure if it was complete. > I don't know how odbc works. I am confused what Access seemed to be > waiting for, rather than announcing the query completed. The status > bar was very slowly creeping from left to right. > > At some point, I hit the Escape Key because I deemed it just wasn't > worth the wait, and I figured I could export the access tables as text > files, then import them into SQL Developer. > > The strange thing is not only that all the records appeared to be in > Oracle WAY before the query finished running, but after I hit Escape > (which therefore meant I would not get a prompt about whether or not > to allow the insert to be done, which one normally gets at the end of > query execution), the data really did appear to be in Oracle, with no > opportunity to cancel the insert. > > Can anyone tell me what might be going on in this situation? > > I have since deleted the data in Oracle because I just don't trust > this process to have completed successfully. > > Thanks > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >