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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28802: invalid mode or data source in configuration file

1 Answers  


PLS-01411: Use of 'REM' token

1 Answers  


PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


ORA-07846: sllfop: string byte record too big for string byte user buffer

1 Answers  






ORA-24023: Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]

1 Answers  


ORA-12923: tablespace string is in force logging mode

1 Answers  


NNF-04004: Invalid string in inputfile

1 Answers  


NNL-00957: Name nodes created: number

1 Answers  


ORA-19333: Invalid flags for the CREATE_DBURI operator

1 Answers  


PLS-00418: array bind type must match PL/SQL table row type

1 Answers  


DRG-50908: invalid maximum number of documents string

1 Answers  


Categories