Pass Through Query Make Table

[Kevin]

So I have the below pass through query of an oracle database that runs in
about 3 minutes and contains over 1 million records. I am using a regular
make table query in access to try create the records in my local database but
I keep getting the ORA-01013 error. I have ODBC property for timeout in both
queries set to zero. What can I do to get these records into my database so
I can move on?

SELECT KTMG_TIME_SHEETS.RESOURCE_USER_ID, KTMG_TIME_SHEETS.STATUS_CODE,
KTMG_TIME_SHEETS.PERIOD_ID,
KTMG_TIME_SHEETS.TIME_SHEET_ID,
KTMG_TIME_SHEET_LINES.TIME_SHEET_LINE_ID, KTMG_TIME_SHEET_LINES.WORK_ITEM_ID,
KTMG_TIME_SHEET_LINES.WORK_ITEM_SET_ID,
KTMG_TIME_SHEET_LINE_DETAILS.ACTUAL_DATE,
KTMG_TIME_SHEET_LINE_DETAILS.ACTUAL_TIME,
KTMG_TIME_SHEET_LINE_DETAILS.TIME_SHEET_LINE_DETAIL_ID
FROM (KTMG_TIME_SHEET_LINES
INNER JOIN KTMG_TIME_SHEETS ON
KTMG_TIME_SHEET_LINES.TIME_SHEET_ID = KTMG_TIME_SHEETS.TIME_SHEET_ID)
INNER JOIN KTMG_TIME_SHEET_LINE_DETAILS ON
KTMG_TIME_SHEET_LINES.TIME_SHEET_LINE_ID
= KTMG_TIME_SHEET_LINE_DETAILS.TIME_SHEET_LINE_ID
WHERE KTMG_TIME_SHEET_LINE_DETAILS.ACTUAL_DATE >= To_Date('12/31/2007',
'mm-dd-yyyy')

 

[Jeff Boyce]

Kevin

Is the fact that it is a "pass through" query significant? Is this actually
a "pass through" query as Access defines it?

Could you do a simple select query from Access on the linked Oracle table,
then convert it to a make-table query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Kevin]

I have only been able to get the results via pass through query. Using a
select query off of the linked tables would never come back with data. So
now the pass through comes back with data but I cant get it save the data
local in my database so i can further query it.

 

[Jeff Boyce]

Kevin

When you say "would never come back with data", do you get an error message?

Are you trying to duplicate a table's data in Access? If so, does Oracle
offer a data export/transformation service similar to that offered by
SQL-Server?

Just a few other thoughts...

Regards

Jeff Boyce
Microsoft Office/Access MVP