ORA-00972: Identifier too long - error

Posted on 2004-11-12
Last Modified: 2013-12-11
Searching experts knowlege base I cannot find the specific scenario that fits my problem.
The SQL is such:
SQL> insert into sys_trading_partner_details_tmp
  2  select * from sys_transaction_type_codes
  3  where sys_transaction_type_code = 'MDI880'
  4  ;
insert into sys_trading_partner_details_tmp
ERROR at line 1:
ORA-00972: identifier is too long
At first i thought it was the length of the table name, but i have since
created another table of equal length.

I could update table manually , but i am trying to perfect a script
to automate a lengthy process.

Please help
Thanks in advance
    LVL 3

    Accepted Solution

    no, the table name is one character too long, orcale only lets object names be 30 characters or less, yours is 31.


    Author Comment

    Perhaps i should learn how to count- Thank You

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now