PL/SQL (MOSC)

MOSC Banner

dbms_snapshot.purge_log

edited Aug 11, 2011 4:05AM in PL/SQL (MOSC) 4 commentsAnswered
hello,
what parameter i to put in num for delete all refreshed snapshots of log. and every time i should to execute this delete.
and how i know, how do logs have a materialize view?
i need to delete all logs.
dbms_snapshot.purge_log('master_table', 2);

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