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

SQL*Loader-00905: Error parsing SQL statement for upi: [number]

1 Answers  


O2F-00304: Invalid filename for the INTYPE file

1 Answers  


ORA-02445: Exceptions table not found

1 Answers  


ORA-01162: block size string in file header does not match configured block sizes

1 Answers  


TNS-12669: Shared server: outbound protocol does not support proxies

1 Answers  






NCR-04017: NCRR: Unable to find the interface instance handle

1 Answers  


O2I-00101: Invalid value for the USERID parameter

1 Answers  


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

1 Answers  


RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


KUP-02001: unrecognized punctuation symbol "string"

1 Answers  


ORA-07672: $PARSE_CLASS failed translating the string into a binary label

1 Answers  


TNS-01201: Listener cannot find executable string for SID string

1 Answers  


Categories