Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-16763: log transport service for some standby database unexpectedly online

1 Answers  


DRG-50942: errors: stringstring

1 Answers  


ORA-39057: invalid worker request string for string jobs.

1 Answers  


PCB-00309: The CONNECT statement is Oracle implementation dependent

1 Answers  


TNS-00286: Max Connect Time (secs) : number

1 Answers  






ORA-13272: geometric object string in table string is invalid

1 Answers  


ORA-01915: invalid auditing option for views

1 Answers  


ORA-31608: specified object of type string not found

1 Answers  


ORA-09718: osnsui: cannot set up user interrupt handler.

1 Answers  


ORA-12910: cannot specify temporary tablespace as default tablespace

1 Answers  


NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


RMAN-06186: PL/SQL package string.string version string in string database is too old

1 Answers  






Categories