Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-12006 – a materialized view with the same user.name already exists

Oracle Database Error Code ORA-12006 Description :

a materialized view with the same user.name already exists

Error Cause:

An attempt was made to create a materialized view with the name of an existing materialized view.

How to Solve :

Create the materialized view using a different name or drop the existing materialized view.