I need to MERGE a small table S(0.25M records) to a huge table T(39M records), they join on the composite primary key, both tables have expactly same columns of the composite primary key.
But the MERGE is aborted with "File system full" error message, the reason is because of the table-scans of the huge table and it uses lots of temporary space.
The huge table is a partitioned table, the data will be merged to the last partition of the huge table.
How can I avoid the table-scan of the huge table? Should I drop the Primary Key of the small table?
Any suggestion or idea are welcome!
But the MERGE is aborted with "File system full" error message, the reason is because of the table-scans of the huge table and it uses lots of temporary space.
The huge table is a partitioned table, the data will be merged to the last partition of the huge table.
How can I avoid the table-scan of the huge table? Should I drop the Primary Key of the small table?
Any suggestion or idea are welcome!