Stack Overflow
Stack Overflow

Questions tagged [ora-00972]

An error message in Oracle : "ORA-00972: identifier is too long".

Description

The following is the description for the ORA-00972 error message.

ORA-00972: identifier is too long

Cause of Error

You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a value that was longer than 30 characters.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Names for tables, clusters, views, indexes, synonyms, tablespaces, and usernames must be 30 characters or less. You must shorten the name to no more than 30 characters for these objects.

Source: http://www.techonthenet.com/oracle/errors/ora00972.php

6 questions
6
votes
2 answers

Oracle - export results to excel with headers/columns more than 30 characters

I can export a Oracle (12.1) SQL results to excel using PL/SQL developer But sometimes the requirements are to give a meaningful name for the column/header for example "total amount for previous 21 days" Obviously, it exceed 30 characters and gets…
Ori Marko
  • 56,308
  • 23
  • 131
  • 233
0
votes
1 answer

I tried UTL_FILE.FOPEN to save file into windows network drive but getting error ORA-00972: identifier is too long

In my pl/sql sprocedure, trying store cursor data into into a test file on our windows network drive. It compiles but when I run it, getting error: ORA-00972: identifier is too long create or replace procedure openDataTest is fHandle …
7184592779
  • 1
  • 2
0
votes
2 answers

ORA-00972 when trying to update field in table

update t set command="select PIN_ID, PIN_STATUS from inventory where trunc(EXPIRY_DATE) <= trunc(sysdate) and pin_status in ('Delivered','GenHold')" where id='8'; im getting this error Error at Command Line : 2 Column : 32 Error report - SQL Error:…
Henry
  • 5
  • 3
0
votes
1 answer

SQLPLUS IF Function in Select Causes Identifier Too Long Error

Below select statement causes ORA-00972: identifier is too long error. Suspect a syntax error. Running this select to generate a view in SQLPLUS on an Oracle db. Please advise. Thanks. SELECT DISTINCT (CASE WHEN PROCEDURE_CODE IS NULL THEN…
Beemer12
  • 1
  • 2
0
votes
1 answer

Oracle issue: ORA-00972: identifier is too long / NHibernate.Exceptions.GenericADOException: could not execute query

This is the query performed by NHibernate against the Oracle database: select compteurra0_.NO_SEQ_CPTE_RAPP_ACCES_INFO_DSQ as NO1_2_, compteurra0_.TXT_INFO_COMPL as TXT2_2_, compteurra0_.TYP_CPTE_RAPP_ACCES_DSQ as TYP3_2_, …
Will Marcouiller
  • 23,773
  • 22
  • 96
  • 162
-1
votes
1 answer

how I can create synonym with "long refence object name"

After I created synonym, reference object name change; my script: create OR REPLACE SYNONYM [schema name].[synonym name] FOR [shema name]."long refence object name"@dblinkname; After created I look for "long refence object name": It's changed to…
erdi yılmaz
  • 352
  • 1
  • 4
  • 15