The DBMS_ADVANCED_REWRITE documentation page for Oracle explains how to declare query rewrites and drop them, but doesn't explain how you can list all declared rewrites in the database.
Is it possible to list all of the declared rewrites?
2
-
select * from DBA_REWRITE_EQUIVALENCES?– Andy DB AnalystCommented Jun 7 at 13:22
-
@AndyDBAnalyst Yes, that works! Please rewrite your comment as an answer so I can accept it– JakaCommented Jun 7 at 18:04
Add a comment
|
1 Answer
select * from DBA_REWRITE_EQUIVALENCES
