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-24501: invalid UTF16 string passed in

1 Answers  


ORA-19760: error starting change tracking

1 Answers  


NNL-00570: save_config [<server_list>] : saves server configuration to parameter file

1 Answers  


ORA-32741: Hang analysis already going on

1 Answers  


PCC-02322: found undefined identifier

1 Answers  


ORA-30682: improper value for argument OPTION_FLAGS

1 Answers  


ORA-25403: could not reconnect

1 Answers  


ORA-09969: scurls: unable to close lock file

1 Answers  


LPX-00657: Invalid output PI '~S'.

1 Answers  


ORA-13152: invalid HHCODE type

1 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


Categories