K
Klatuu
INSERT INTO [BACKORDER_SNAPSHOT_8_10_Cleaned up] SELECT
[BACKORDER_REPORT_072907 to 080407].* FROM [BACKORDER_REPORT_072907 to
080407], [BACKORDER_SNAPSHOT_8_10_Cleaned up];
The above query runs for 15 -20 minutes then returns error 3183 (Not enough
space on temporary disk.)
There is no temporary disk involved. The user has the mdb on her local
drive. It is not a split database, it is used by a QA tester to validated
data in another database.
(that is why the naming so so ugly)
A previous version worked well, but there were some name changes in the
mainframe database.
The import also uses an import spec.
[BACKORDER_REPORT_072907 to 080407].* FROM [BACKORDER_REPORT_072907 to
080407], [BACKORDER_SNAPSHOT_8_10_Cleaned up];
The above query runs for 15 -20 minutes then returns error 3183 (Not enough
space on temporary disk.)
There is no temporary disk involved. The user has the mdb on her local
drive. It is not a split database, it is used by a QA tester to validated
data in another database.
(that is why the naming so so ugly)
A previous version worked well, but there were some name changes in the
mainframe database.
The import also uses an import spec.