ORA-42693
Cannot create JSON-relational duality view 'string': Dependent table 'string' cannot be marked with DELETE annotation
Cause
Dependent (dimension) tables can only be marked with DELETE if they are linked to their parent table with a foreign key constraint. The foreign key constraint cannot be a RELY constraint. It also cannot have an action defined (ON DELETE SET NULL or ON DELETE CASCADE).
Action
Do not mark the specified table with DELETE annotation. Or, ensure that a foreign key constraint is defined between the specified table and its parent table. If a foreign key constraint already exists, make sure it is not RELY and it has no action defined.