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-29003: SSL transport detected mismatched server certificate.

1 Answers  


TNS-04001: %s

1 Answers  


ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML

1 Answers  


ORA-31413: change set string is currently being advanced

1 Answers  


ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table

1 Answers  






ORA-29904: error in executing ODCIIndexClose() routine

1 Answers  


ORA-01633: Real Application Clusters Option needed for this operation

1 Answers  


ORA-28527: Heterogeneous Services datatype mapping error

1 Answers  


ORA-13438: GeoRaster metadata pyramid type error

1 Answers  


ORA-12631: Username retrieval failed

2 Answers  


RMAN-12017: could not locate pieces of backupset key string

1 Answers  


TNS-12663: Services required by client not available on the server

1 Answers  


Categories