My Oracle Support Banner

ORA-600 [12869] Error When Creating An MVIEW In SYS SCHEMA (Doc ID 1310339.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Standard Edition - Version: and later   [Release: 11.1 and later ]
Information in this document applies to any platform.


An ORA-600 [12869] error is reported when trying to create a materialized view in the SYS schema.  The error produces when performing the following scenario in the SYS schema:

1. Create a materialized view on a remote table over a db link.
2. Now try to create a materialized view with the same name as the remote table name on an another table.

The error does not reproduce when this is performed in schemas other than SYS.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.