Hello,
I work with an ETL that integrates data in Oracle.
I need to integrate data in a temporary table which is a copy of another table (but without the constraints). Then, I need to use the data stored in this table during my processing.
The problem is that the data disappears from my temporary table after integration. Indeed, I have "ON COMMIT PRESERVE ROWS" which is added automatically. I need to keep the data after the COMMIT, but also after the SESSION CLOSE. I will empty the table by myself, but I don't want Oracle to do it.
How can I do it?
Thanks.