Category Archives: ORA Database Error Messages

ORA-31092: invalid SQL name “string”

oracle

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

Back to previous menu

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

ORA-31091: empty string specified as a SQL name

oracle

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

Back to previous menu

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

ORA-31090: invalid database schema name “string”

oracle

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

Back to previous menu

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

ORA-31089: schema “string” does not target namespace “string”

oracle

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

Back to previous menu

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

ORA-31088: object “string”.”string” depends on the schema

oracle

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

Back to previous menu

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

ORA-31087: insufficient privileges to delete schema “string”

oracle

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

Back to previous menu

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

ORA-31086: insufficient privileges to register schema “string”

oracle

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

Back to previous menu

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

ORA-31085: schema “string” already registered

oracle

ORA-31085: schema "string" already registered
Cause: An attempt was made to register a schema with the same URL as a previously registered schema
Action: Register the schema with a different URL

Back to previous menu

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

ORA-31084: error while creating table “string”.”string” for element “string”

oracle

ORA-31084: error while creating table "string"."string" for element "string"
Cause: An error occurred while trying to create the table based on the declaration for the identified element
Action: Fix the identified error and try again

Back to previous menu

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

ORA-31083: error while creating SQL type “string”.”string”

oracle

ORA-31083: error while creating SQL type "string"."string"
Cause: An error occurred while trying to create the SQL type based on the specification of a complex type
Action: Fix the identified error and try again

Back to previous menu

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