Post Upgrade To 22.214.171.124, "create or replace view" execution fails with "ORA-01720: Grant Option Does Not Exist"
(Doc ID 1628033.1)
Last updated on SEPTEMBER 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
After upgrading from 184.108.40.206 to 220.127.116.11, you encounter the following error while executing the "create or replace view" statement:
Views were created before the upgrade and "CREATE OR REPLACE VIEW" had worked fine.
For example the following testcase will run without errors on version 18.104.22.168, while the last statement 'create or replace view testv as select * from u2.test' will fail on 22.214.171.124
Upgrade to 126.96.36.199 from a previous version.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document