ORA Database Error Messages

ORA-12041: cannot record ROWIDs for index-organized table “string”.”string”

oracle

ORA-12041: cannot record ROWIDs for index-organized table “string”.”string”
Cause: Index-organized tables do not have ROWIDs. Therefore a materialized view log that records the ROWIDs of an index-organized table could not be created.
Action: Do not include the WITH ROWID option when using the CREATE MATERIALIZED VIEW command and do not include the ADD ROWID option when using the ALTER MATERIALIZED VIEW command if the master table is index-organized.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/