Category Archives: ORA Database Error Messages

ORA-32306: updatable materialized views with user-defined types must use SELECT *

oracle

ORA-32306: updatable materialized views with user-defined types must use SELECT *
Cause: An attempt was made to create an updatable materialized view with user-defined types where the definition query did not use SELECT * at the topmost level
Action: Rewrite the definition query so that SELECT * is used at the topmost level

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32305: RepAPI materialized views with user-defined types are not supported

oracle

ORA-32305: RepAPI materialized views with user-defined types are not supported
Cause: An attempt was made to create a RepAPI materialized view with user-defined types
Action: Do not create a RepAPI materialized view with user-defined types

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32304: materialized views with user-defined types cannot use prebuilt table

oracle

ORA-32304: materialized views with user-defined types cannot use prebuilt table
Cause: An attempt was made to create a materialized view with the ON PREBUILT TABLE option
Action: Do not create the materialized view with the ON PREBUILT TABLE option

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32303: mviews with user-defined types cannot reference multiple master sites

oracle

ORA-32303: mviews with user-defined types cannot reference multiple master sites
Cause: For materialized views with user-defined types, the definition query cannot reference tables from different master sites
Action: Do not create materialized views with user-defined types referencing multiple master sites

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32302: object materialized views must be object ID based

oracle

ORA-32302: object materialized views must be object ID based
Cause: An attempt was made to create an object materialized view that is not object ID based
Action: Create the materialized view using the OF clause but omit any ROWID or PRIMARY KEY clauses

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32301: object-relational materialized views must be primary key based

oracle

ORA-32301: object-relational materialized views must be primary key based
Cause: An attempt was made to create an object-relational materialized view that is not primary key based
Action: Create the materialized view with the PRIMARY KEY keyword

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32300: cannot drop a secondary materialized view “string”.”string”

oracle

ORA-32300: cannot drop a secondary materialized view "string"."string"
Cause: An attempt was made to drop a materialized view of a nested table column's storage table
Action: Drop the materialized view that contains the nested table column. This will implicitly drop all secondary materialized views

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32168: Cannot perform operation on a null AnyData

oracle

ORA-32168: Cannot perform operation on a null AnyData
Cause: The AnyData instance on which the operation was attempted was null
Action: Use a valid, non-null AnyData instance to perform this operation

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32167: No payload set on the Message

oracle

ORA-32167: No payload set on the Message
Cause: An attempt was made to enqueue a message without setting a payload on it
Action: Set a payload on the message before calling the send method

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32166: Cannot get XA connection

oracle

ORA-32166: Cannot get XA connection
Cause: Incorrect dbname string was passed or the XA connection has not been opened
Action: Pass the correct dbname string or check if the XA connection is open

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/