Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

One (or more) of the OraSnap reports has errors. How do I modify the queries?

April 26, 2017errors orasnap queries reports

0

Posted

One (or more) of the OraSnap reports has errors. How do I modify the queries?

1 Answer

0

Posted

Unfortunately, Oracle is constantly adding/removing/renaming columns in different versions of Oracle. Column names can vary from platform to platform and version to version. I try to use DBA% views whenever possible – however, these can change from release to release. Don’t be afraid to modify the corresponding query to suite your particular platform and/or version of Oracle.