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

ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 Answers  


TNS-01020: STATUS of the LISTENER

1 Answers  


PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loop

1 Answers  


NNL-00500: Shows information on domains served by this server

1 Answers  


ORA-30945: Could not create mapping table 'string'

1 Answers  


LSX-00311: local element or attribute shouldn't be namespace qualified

1 Answers  


SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  


ORA-15044: ASM disk 'string' is incorrectly named

1 Answers  


ORA-24377: invalid OCI function code

1 Answers  


ORA-16013: log string sequence# string does not need archiving

1 Answers  


Categories