Oracle Database Errors or Warnings from Error ORA-31086 to ORA-31095

SQLServerF1

ORA-31086: insufficient privileges to register schema “string”
Cause: An attempt was made to register a schema without sufficient privileges.
Action: Make sure that the user has sufficient privileges to register the schema.
ORA-31087: insufficient privileges to delete schema “string”
Cause: An attempt was made to delete a schema resource without sufficient privileges.
Action: Make sure that the user has sufficient privileges to delete the schema.
ORA-31088: object “string”.”string” depends on the schema
Cause: An attempt was made to delete a schema which has dependent objects.
Action: Either drop the dependent objects prior to deleting the schema or use the CASCADE or FORCE options.

ORA-31089: schema “string” does not target namespace “string”
Cause: The schema document contains references (via include and import definitions) to other schemas that do not belong to valid namespaces.
Action: Make sure that all schemas referenced via include definitions target the same namespace as the parent schema. Further make sure that the namespace specified in the import definition matches the actual target namespace of the specified schema.
ORA-31090: invalid database schema name “string”
Cause: The XML schema document contains an invalid database schema name For example, the value of attribute SQLSchema
Action: Make sure that all database user/schema names specified in the XML schema document refer to existing database users/schemas.
ORA-31091: empty string specified as a SQL name
Cause: The XML schema document contains a null SQL name. For example, the values of attributes SQLName, SQLType, defaultTable.
Action: Make sure that all names of SQL schema objects specified in the XML schema document are valid SQL names. Otherwise, remove such attributes from the schema and try again.

ORA-31092: invalid SQL name “string”
Cause: The XML schema document contains an invalid SQL name. For example, the values of attributes SQLName, SQLType, defaultTable.
Action: Make sure that all names of SQL schema objects specified in the XML schema document are valid SQL names. This implies that the database length and other restrictions on names be satisfied.
ORA-31093: null or invalid value specified for parameter : string
Cause: The argument value passed for the given parameter is null or invalid.
Action: Make sure that all the input argument values are valid.
ORA-31094: incompatible SQL type “string” for attribute or element “string”
Cause: The SQL type information provided in the XML schema is not compatible with the XML datatype for the specified attribute or element.
Action: Make sure that the specified SQL types are compatible with the declared XML datatypes.
ORA-31095: cannot generate string : “string.string” already exists
Cause: The type/table name specified in the XML schema document cannot be generated because it is already being used.
Action: Use different names for types/tables or use the NOGEN mode so that schema compiler does not generate new types/tables.

Above are list of Oracle Database Errors or Warnings from Error ORA-31086 to ORA-31095 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *