Oracle Solution for Error ora-42300
ORA-42300: an Editioning view is already defined on this table
What triggered 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.
What should we do to fix it:
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.