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

TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

1 Answers  


EXP-00066: Object table string is missing its object identifier index

1 Answers  


ORA-24197: JAVA stored procedure throws JAVA exceptions

1 Answers  


PLS-00512: Implementation Restriction: 'string': Cannot directly access remote package variable or cursor

1 Answers  


ORA-16179: incremental changes to "string" not allowed with SPFILE

1 Answers  






LPX-00605: Invalid attribute '~1S' in element '~2S'.

1 Answers  


PLS-00425: in SQL, function argument and return types must be SQL type

1 Answers  


ORA-16803: Unable to query a database table or fixed view.

2 Answers  


PCC-02021: Found newline while scanning string literal

1 Answers  


DRG-10569: table or column does not exist: string

1 Answers  


ORA-14630: subpartition resides in offlined tablespace

1 Answers  


EXP-00004: invalid username or password

1 Answers  


Categories