In some environment, all views are generated like the following.
CREATE OR REPLACE VIEW "SCHEMA1"."V1"
("SCHEMA1", "SCHEMA1", "SCHEMA1", ...)
As shown above, all column names are the view's schema name.
Therefore, issuing it causes the following error.
SQL0612N "SCHEMA1" is a duplicate name.
The user used in the IDMT has SELECT_CATALOG_ROLE privilege.
But still the following SQL issued by IDMT causes the following error.
SELECT MAX(DBMS_LOB.GETLENGTH("PASSWORD")) FROM "SINGLESM"."BIN$tKhDCiSNVIzgRAAhKKX/0A=$0"
ORA-01031 Insufficient privilege
Pinned topic VIEW is not generated properly in some environment
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-23T05:50:18Z at 2012-06-23T05:50:18Z by mohkawa