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

LPX-00281: unsupported encoding "~s"

1 Answers  


ORA-30500: database open triggers and server error triggers cannot have BEFORE type

1 Answers  


ORA-31438: duplicate change table string

1 Answers  


ORA-07741: slemop: $OPEN failure

1 Answers  


IMG-00902: VIR signature free failed

1 Answers  


ORA-16811: apply instance not recorded by the Data Guard broker

1 Answers  


ORA-02264: name already used by an existing constraint

1 Answers  


ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA

1 Answers  


TNS-12555: TNS:permission denied

2 Answers  


ORA-27197: skgfprs: sbtpcrestore returned error

1 Answers  


ORA-26717: SCN limit reached

1 Answers  


NZE-29195: CRL is expired

1 Answers  


Categories