The following is the cause of this error:
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 you can take to resolve this issue: 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.
Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory
Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material. Disclaimer
Home Disclaimer Advertise Contact Privacy Policy
Copyright © 2004-16 Paked.com. All rights reserved.
Note: Site best viewed at 1024 x 768 or higher screen resolution