| Delete data from v$log_history [message #297491] |
Fri, 01 February 2008 01:45  |
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  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
