desc?

Originally Posted by
PaulH
I did have the foresight to include the seq number as part of my arch name. I can certainly parse the name and get the right answer but I was hoping there was some table that stored the name of the whole arhive file so I can use that data instead of parsing every name.
Did you try desc v$archived_log?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb