Home » RDBMS Server » Server Administration » Delete data from v$log_history
Delete data from v$log_history [message #297491] Fri, 01 February 2008 01:45 Go to next message
Messages: 35
Registered: April 2007
Location: Malaysia

I have a report that pull data from the v$log_history base on Max sequence number. I did perform a resetlog on the db causing the wouldn't get the latest data as it will get max sequence number which still stamp last month.

Is there a way to delete the data from v$log_history?

Regards, Kelvin
Re: Delete data from v$log_history [message #297492 is a reply to message #297491] Fri, 01 February 2008 02:01 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there a way to delete the data from v$log_history?

The number of records is defined by the parameter MAXLOGHISTORY given at database creation time.

Previous Topic: Logminer not showing recent actions
Next Topic: Undo tbsp taking more space than the table size
Goto Forum:

Current Time: Sat Oct 22 17:21:59 CDT 2016

Total time taken to generate the page: 0.09404 seconds