Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create Materialized View

user12983407Apr 29 2023 — edited Apr 29 2023
  1. Created Table X with Primary in the database
  2. Created Table Y with Foreign key reference with X table primary key clause cascade delete.
  3. Trying to create a materialized view and it shows the below error.

ORA-00955: name is already used by an existing object

Workaround:

  1. Remove Foreign key from Table Y
  2. Materialized view created successfully.

Why it is not allowing Foreign key and Materialized view together.?
Comments
Post Details
Added on Apr 29 2023
5 comments
472 views
1 mention