My Oracle Support Banner

ORA-00972 From Oracle Spatial Studio (Doc ID 2691585.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Oracle Spatial and Graph - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

After successfully installing and starting up Oracle Spatial Studio 19.*, an ORA-972 is generated when attempting to connect to the database with valid connection and schema details:

Log file at C:\Users\<USER>\.sgtech\logs\SGTech_******_<computer_name>\ shows:

####Jul 16, 2020 7:52:38 AM oracle.sgtech.jee.api.API isValidConnection
INFO: Validating BASIC connection type...
####Jul 16, 2020 7:52:44 AM oracle.sgtech.util.sql.JDBCUtils checkSchemaQuotaPrivs
WARNING: ORA-00972: identifier is too long

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.