Oracle Error Message
ORA-42300: an Editioning view is already defined on this table
Reason for the Error
An attempt was made to create an Editioning view on a table on which another Editioning view is already defined in the same Edition. This violates a restriction that at most one Editioning view may be associated with any base table in a given Edition.
Solution
Create the new view as a regular view or, if the view being created is really intended to be an Editioning view associated with this table, drop the existing Editioning view before creating the new one.

Leave a Review