How to setup table with no redolog and Undo activity ?
In Oracle 11g/12c Standard Edition One/TWo edition database.
How to setup a table, where any DML activity on the table is not recorded (Redolog, Undo) for recovery.
We are planning to create a table where there will be lot of DML activity. But at the same time this is not a critical table needed for any recovery purpose.
But since we have lot of DML activity going on this table, we wanted to make sure No redo/Undo is recorded and put an additional overhead on the database.
1) Can we setup table with the above option during the table creation time ?