Hi All,

I m having a object named v_firstfit_mother .
Now I want ot know how many objects(table,view or syn) are created in local schema which contains this name like '%v_firstfit_mother%'

Pl help.


Rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

Hi Rekha,

You may try the following query in the local schema:

select object_type, object_name
from user_objects
where object_name like '%V_FIRSTFIT_MOTHER%' ;

Hope that helps.

With regards,
azizmasih

Thanks

azizmasih

Rekha