ORA-12058: materialized view cannot use prebuilt table
Cause: An attempt was made to use the prebuilt tables.
Action: Reissue the SQL command using BUILD IMMEDIATE or BUILD DEFERRED.
Custom Search

More Oracle errors
SQL-02143Target object has not been properly allocated
RMAN-20034resync not needed
ORA-44317database open read-only
ORA-03218invalid option for CREATE/ALTER TABLESPACE
PGU-00387could not locate toolkit resource file, string
CLST-03101Enter the password for user string.
ORA-15215missing or invalid user name
ORA-54523inner rings of same outer ring cannot touch more than once
ORA-02450Invalid hash option - missing keyword IS
ORA-02210no options specified for ALTER TABLE
ORA-01185logfile group number string is invalid
PGA-21222commit failed during warm start of local LU string
ORA-38950Source platform string not cross platform compliant
ORA-38807Implementation restriction: an edition can have only one child
ORA-32508no such watchpoint id
NZE-29029SSL handshake already completed
ORA-37605error during OLAP AW UPDATE
SQL*Loader-00533OCI return status: unknown, value is number
DRG-11868Too Many Redirections
OCI-19201Datatype not supported

TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-32701Hang detected
ORA-10877error signaled in parallel recovery slave string
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16766Redo Apply is stopped
ORA-16664unable to receive the result from a database
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
ORA-16665timeout waiting for the result from a database
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated

Your own TOP 20 Oracle errors
ORA-12058materialized view cannot use prebuilt table