Something between GTT/PTT and permanent tables to avoid archived redo log volume
Can't find a good solution -- 19c database in ARCHIVELOG mode, need "temporary" tables that are shared between a small number of sessions (2-3), and I want the equivalent of NOLOGGING to avoid almost all redo log switching and archived log generation and transfer to archive destination. GTTs and PTTs won't work since the contents are private to the session. Not concerned about failure during creation and usage; they can be recreated quickly but are very large. Any combination of Oracle Database features I can use to accomplish these goals? Thanks.