If you need to search for table/tables in your databases, try query below. Change the table name accordingly. This is pretty much like Oracle DBA_TABLES/DBA_OBJECTS.
select database, objname, owner
from _v_obj_relation_xdb
where objname IN ('ARRANGEMENT_ACTIVITY','SUBSCRIBER_ARRANGEMENT')
and objtype='TABLE'
No comments:
Post a Comment