ORA-00918: Column Ambiguously Defined
(Doc ID 1513816.1)
Last updated on MAY 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Using two DBs with 188.8.131.52
This behavior was not reproduced in 184.108.40.206
Receive an ORA-00918: column ambiguously defined while selecting over DBlink.
1. column names of length 30
2. database link (remote query)
3. ANSI join syntax
4. fails with ora-918
Upgrading to 220.127.116.11.
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