Report which shows reserved objects of specific folders

Hello,

I would like to have a report, which shows me which objects are reserved under a specific folder which all it's subfolders.

How would you write such a report?

Thanks

Peter

Find more posts tagged with

Comments

Appu_Nair1

If it is a oracle server tree walk is given to you by oracle itself.Dtree.reserved=128 means it is reserved.There is dtree.reservedby thats sayswho diid it as well

this xtremely good reply by Lindsay

https://knowledge.opentext.com/knowledge/cs.dll/open/34457730

should give you how to write things with SQLserver,it is a gem of a post.

This is how in Oracle you writ

select level, name,dataid,parentid from dtree where reserved=128 connect by prior dataid=parentid

start with <the dataid of a container>

if you need to walk projects and other volumes you would ABS it or as Lindsay showed a while back it is better to say

it explicitly something like connect by prior dataid=parentid or -dataid=parentid not sure what the syntax is there