Re: ASM directory path info from ASM instance

Hi Mark,

Thanks. in-line comments

On Mon, 28 Mar 2005 17:05:40 -0800, Mark Bole <makbo_at_pacbell.net> wrote: ....
>
> select
> b.name, CONNECT_BY_ROOT b.name root,
> SYS_CONNECT_BY_PATH(b.name, '/') path
> from v$asm_alias b
> connect by prior b.reference_index = b.parent_index
>
> --
> Mark Bole
> http://www.bincomputing.com

I missed the fact that directories are included in the v$asm_alias as part of a hierarchy. Excellent.

Regards,

Mike Thomas

--
http://www.freelists.org/webpage/oracle-l