To delete rows from snapshotlog for at least one snapshot run this (replace 'MASTER' with the actual table name): SQL> exec dbms_snapshot.purge_log('MASTER', 1, 'DELETE'); This will delete rows from the oldest snpashot.
© 2005 tiplib.com