If You don’t remember exactly the name of the view or table, so this query is for You:
col SHORT_OBJECT_NAME FOR a30
SELECT
SUBSTR( ob.OBJECT_NAME,1,30)"SHORT_OBJECT_NAME",
SUBSTR( ob.OWNER,1,15)"SHORT_OWNER" ,
ob.OBJECT_TYPE,ob.CREATED
FROM dba_objects ob
WHERE object_name LIKE UPPER('%&template%') escape '\'
order by 1,2;
SELECT
SUBSTR( ob.OBJECT_NAME,1,30)"SHORT_OBJECT_NAME",
SUBSTR( ob.OWNER,1,15)"SHORT_OWNER" ,
ob.OBJECT_TYPE,ob.CREATED
FROM dba_objects ob
WHERE object_name LIKE UPPER('%&template%') escape '\'
order by 1,2;
Leave a Reply