GoogleCloudPlatform / database-assessment

Database Migration Assessment
https://googlecloudplatform.github.io/database-assessment/
Apache License 2.0
62 stars 35 forks source link

BUG: 11g SQL Script Accessing v$diag_alert_ext that do not exists #102

Closed ersantosnet closed 1 year ago

ersantosnet commented 2 years ago

Description

11g SQL Script accessing v$diag_alert_ext that do not exists in this DBVersion

Version

No response

Priority

priority:0

What oracle database version are you seeing the problem on?

No response

Relevant log output

No response

smancinijr commented 2 years ago

This view exists in 11.2.0.4 It's possible that is not present in older 11g releases. I'm updating the query to use X$DBGALERTEXT that should be compatible with 11.2.0.1 and superior.

smancinijr commented 2 years ago

Based on MOS note How To Query Oracle X$ Tables From Another User Other Than SYS? (Doc ID 2009144.1) and in some testing, we can't substitute the original view.

"grant select any dictionary" and "grant select any table" also doesn't work.