Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to delete archive log file

VaibhavDixitDec 14 2011 — edited Dec 14 2011
hii,

presently i am working on oracle 10gR2 on windows server 2003.
hard disk drive is almost full.



when i execute this command
"DELETE EXPIRED ARCHIVE LOG ALL";

it give message

"specifies does not match any archive log in the recovery catalog"



how can i delete archive log files ??

Regards
Vaibhav Dixit
This post has been answered by KanchDev on Dec 14 2011
Jump to Answer

Comments

Frank Kulash

Hi, @user-e2y4b
This question was posted in the English-language space. There's a separate space for Spanish language:
Base de Datos Discusión General — oracle-tech
I'll try to move the thread there for you.

mathguy

Please note that this forum es solo en ingles. Either you state your question and accept answers in English, or look for a Spanish language forum (knowing that participation will be much more limited).
As to the error: Tables like AH135D are understood within the subquery (the join), but not outside it. The UPDATE statement only sees the result of the subquery, with its columns.
Either move the WHERE clause INSIDE the query, or give the subquery and its columns aliases and use those in the WHERE clause. (You may leave out the subquery alias - and perhaps even the column aliases, if there is no risk of confusion - but in a problem like this it is a best practice to alias the subquery and also the columns within it.)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 11 2012
Added on Dec 14 2011
20 comments
301,258 views