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
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a way to delete the data from v$log_history?

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

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


Current Time: Thu Dec 08 02:11:46 CST 2016

Total time taken to generate the page: 0.06202 seconds