Re: Deleting v$archived_log obsolete data

You don't delete information from V$ARCHIVED_LOG. The system takes care of that for you. You shouldn't be directly deleting from these views. V$ARCHIVED_LOG really queries SYS.X$KCCAL which isn't a real table anyway.

Cheers,
Brian

Ben wrote:
>
> Hi all. Our systems maintains a list of the archive logs using the
> v$archived_log. Well, somehow it got full of really old data. I want
> to delete 99.9% of the stuff in there, but I get all sorts of errors
> that it is not the right table or view. How do I get around this?
>
> Thanks,
> Ben..

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"