Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Keeping rows in a temporary table

User_TPE2GJan 17 2023

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.

Comments
Post Details
Added on Jan 17 2023
3 comments
722 views