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-03216: Tablespace/Segment Verification cannot proceed

1 Answers  


KUP-04029: numeric field overflowed

1 Answers  


ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


ORA-00019: maximum number of session licenses exceeded

1 Answers  






ORA-30695: JDWP message format problem

1 Answers  


ORA-10561: block type 'string', data object# string

1 Answers  


ORA-29263: HTTP protocol error

1 Answers  


NID-00128: Cannot revert change of database, change not in progress

1 Answers  


LPX-00279: invalid no_proxy "~s"

1 Answers  


ORA-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  


ORA-19604: conversation file naming phase is over

1 Answers  


Categories