ORA-12058: materialized view cannot use prebuilt table



ORA-12058: materialized view cannot use prebuilt table..

Answer / guest

Cause: An attempt was made to use the prebuilt tables.

Action: Reissue the SQL command using BUILD IMMEDIATE or
BUILD DEFERRED.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00207: controlfiles are not for the same database

1 Answers  


ORA-09811: Unable to initialize package.

1 Answers  


PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server

1 Answers  


ORA-24070: cannot upgrade queue table string while it is being downgraded

1 Answers  


ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.

1 Answers  


ORA-07209: sfofi: file size limit was exceeded.

1 Answers  


DRG-11729: phrase does not have any narrower terms of this type

1 Answers  


ORA-16763: log transport service for some standby database unexpectedly online

1 Answers  


ORA-00981: cannot mix table and system auditing options

1 Answers  


ORA-01238: cannot shrink datafile string

1 Answers  


ORA-27491: repeat_interval and start_date cannot both be NULL

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


Categories