| Problem with Deleting Flashback Logs [message #360777] |
Mon, 24 November 2008 00:35  |
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
|
Member |
|
|
Hi,
Flashback logs is enabled on the database, actually the target was configured for 1 day (1440) but it doesn't get deleted automatically.
And when I issued a statement to delete it ... the statement went through but the flashback logs is still there not deleted.
shutdown immediate
startup mount
alter database flashback off;
alter database open;
Please what could be the problem here? Meanwhile, when I did the same on my Windows XP with the same version of Oracle10g it get deleted. Is there a problem with Win 2003 server deleting flashback logs?
Regards,
Texas B
|
|
|
|
|
|
| Re: Problem with Deleting Flashback Logs [message #360796 is a reply to message #360792] |
Mon, 24 November 2008 01:01  |
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
|
Member |
|
|
Hi Michel,
Thanks for your reply.
But when I did the same on my work station (Win XP) @ home it gets deleted but why not deleting on the Win 2003 server?
That is my question. A client is on my neck for this and I need to find a solution.
Regards,
Texas B
|
|
|
|
|
|
| Re: Problem with Deleting Flashback Logs [message #360815 is a reply to message #360805] |
Mon, 24 November 2008 01:29 |
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
|
Member |
|
|
Actually that's true. The size of FRA on my workstatin is 2G while the size @ office is 150G.
One more question please ... I know that when FRA is needed the flashback logs get deleted ... will it be deleted in this situation?
Thanks so much ... now I can go relax.
Regards,
Texas B
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
