Database Administration (MOSC)

MOSC Banner

How to setup table with no redolog and Undo activity ?

edited Feb 24, 2019 4:00AM in Database Administration (MOSC) 9 commentsAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center