Oracle 11g Error Codes and Solution Suggestions from ORA-23500 to ORA-24000 ORA-23500: cannot switch master for a multi-tier materialized view repgroup “string”.”string” Cause: An attempt was made to switch master for a materialized view repgroup when its parent repgroup is also a materialized view repgroup. This is not allowed. Action: Drop and recreate the materialized view repgroup…
Category: Oracle
Oracle 11g Error Codes and Solution Suggestions from ORA-23400 to ORA-23500
Oracle 11g Error Codes and Solution Suggestions from ORA-23400 to ORA-23500 ORA-23400: invalid materialized view name “string” Cause: A null, misspelled, or badly formed materialized view name was given to dbms_mview.refresh. Action: Provide a valid materialized view name to dbms_mview.refresh. ORA-23401: materialized view “string“.”string” does not exist Cause: A materialized view name was given to dbms_mview.refresh that is…
Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400
Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400 ORA-23301: mixed use of deferred rpc destination modes Cause: Replication catalog determined deferred RPC destinations were mixed with destination determined by other mechanisms in the same transaction. Action: Do not mix destination types in the same transaction. ORA-23302: application raised communication failure during deferred RPC Cause: An…
Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000
Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000 ORA-22800: invalid user-defined type Cause: An attempt was made to use an incomplete type as a constructor. Action: Complete the type definition before using it in a query. ORA-22801: invalid object row variable Cause: The specified object row variable is not available in the scope of name…
Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700
Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700 ORA-22303: type “string”.”string” not found Cause: The user is trying to obtain information for a type that cannot be found. Action: Check that the schema is correct and that the type has been created correctly. ORA-22304: input type is not an object type Cause: The user is…
Oracle 11g Error Codes and Solution Suggestions from ORA-22000 to ORA-22300
Oracle 11g Error Codes and Solution Suggestions from ORA-22000 to ORA-22300 ORA-22053: overflow error Cause: This operation’s result is above the range of Oracle number. Action: Decrease the input value(s) so that the result is in the range of Oracle number. ORA-22054: underflow error Cause: This operation’s result is below the range of Oracle number. Action: Increase the input…
Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000
Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000 ORA-20000: string Cause: The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. ORA-21300: objects option not installed Cause: The objects option is not installed…
Oracle 11g Error Codes and Solution Suggestions from ORA-19900 to ORA-20000
Oracle 11g Error Codes and Solution Suggestions from ORA-19900 to ORA-20000 ORA-19900: RESETLOGS must be specified after recovery to new incarnation Cause: Recovery was done to an incarnation after changing the destination incarnation using RMAN’s RESET DATABASE command. Action: Open the database with the RESETLOGS option. ORA-19901: database needs more recovery to create new incarnation Cause: Recovery was…
Oracle 11g Error Codes and Solution Suggestions from ORA-19700 to ORA-19900
Oracle 11g Error Codes and Solution Suggestions from ORA-19700 to ORA-19900 ORA-19700: device type exceeds maximum length of string Cause: The device type indicated is invalid. Action: Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of string Cause: The device name indicated is invalid. Action: Supply a correct device name and retry the allocation….
Oracle 11g Error Codes and Solution Suggestions from ORA-19600 to ORA-19700
Oracle 11g Error Codes and Solution Suggestions from ORA-19600 to ORA-19700 ORA-19600: input file is string string (string) Cause: This message identifies the input file for a failed copy operation. Both the file number and name (if the name has been determined) are shown. For a datafile, the file number refers to the datafile’s absolute file number as shown…