SELECT * FROM ALL_ALL_TABLES WHERE OWNER = :OWNER SELECT * FROM ALL_VIEWS WHERE OWNER = :OWNER
Getting the differences between the two sources it’s pretty easy:
SELECT A.* FROM ALL_ALL_TABLES A LEFT JOIN APPS.FND_TABLES B ON A.TABLE_NAME = B.TABLE_NAME WHERE A.OWNER = :OWNER AND B.TABLE_NAME IS NULL
If you are interested on Oracle internals you can find more goodies by querying the Oracle dictionary table:
SELECT * FROM DICT WHERE TABLE_NAME LIKE '%VIEW%'
One of such goodies is the view that stores the list of Materialized views:
SELECT * FROM DBA_MVIEWS
PS: I know that these are pretty basic stuff for APPS DBAs though not all of us discovered them from beginning.
No comments:
Post a Comment