Re: ASM directory path info from ASM instance
- From: mhthomas <qnxodba@xxxxxxxxx>
- To: makbo@xxxxxxxxxxx
- Date: Mon, 28 Mar 2005 22:48:08 -0500
Hi Mark,
Thanks. in-line comments
On Mon, 28 Mar 2005 17:05:40 -0800, Mark Bole <makbo@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
