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-01507: database not mounted

1 Answers  


PLS-01912: : instance must of be of type 'string'

1 Answers  


RMAN-06427: recovery catalog already exists

1 Answers  


ORA-00376: file string cannot be read at this time

1 Answers  


RMAN-08520: channel string: scanning archive log string

1 Answers  






LSX-00204: extra data at end of complex element

1 Answers  


ORA-08270: sksachk: Illegal archival control string

1 Answers  


ORA-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  


NNL-00971: Query ID: number

1 Answers  


PLS-00533: Tables of non_queryable types are not supported.

1 Answers  


ORA-22809: nonexistent attribute

1 Answers  


ORA-09751: pw_attachPorts: server call pws_attach failed.

1 Answers  


Categories