Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-40593

name conflicts were found during execution of DBMS_JSON.CREATE_VIEW: string

Cause

An attempt was made to create a view using an annotated Javascript Object Notation (JSON) data guide with the name of a column that already exists.


Action

Change the preferred name of the column in the annotated Javascript Object Notation (JSON) data guide. An alternative is to set parameter resovleNameConflicts in procedure DBMS_JSON.CREATE_VIEW to TRUE and the procedure will automatically resolve the view column name conflicts by appending a sequence number.