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-00335: online log string: No log with this number, log does not exist

1 Answers  


TNS-12538: TNS:no such protocol adapter

1 Answers  


ORA-25505: the system is not in quiesced state

1 Answers  


ORA-36316: (PHYS02) Relation workspace object must be a single-dimensional relation that relates one INTEGER dimension to another.

1 Answers  


ORA-22994: source offset is beyond the end of the source LOB

1 Answers  






LPX-00111: invalid ~1s "~2S" (not a Nmtoken)

1 Answers  


ORA-31662: metadata transform name can not be defaulted

1 Answers  


DRG-11828: Conflict

1 Answers  


ORA-06701: TLI Driver: incorrect number of bytes written

1 Answers  


ORA-24019: identifier for string too long, should not be greater than string characters

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  


TNS-04047: Invalid specification for destination

1 Answers  


Categories