Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: I cant insert

Re: Help: I cant insert

From: Sanjaya Ganesh <sganesh_at_apple.com>
Date: 9 May 1999 23:07:12 -0500
Message-ID: <37364d60@discussions>

Hello,

        This is because your column name percent_..... is more than 31 characters long. Unfortunately, you can mostly see in your dba_tab_columns that only the first 31 chars!! So you have live the rest of life with this name given by oracle or drop and recreate the table again.

Hope this helps
Sanjay

yong321_at_yahoo.com wrote:
>Is the error below because the string in the parentheses too long? Thanks.>
>Yong
>Email:yong321_at_yahoo.com
>
>SQL> insert into kpi_period 2
>(call_length,speed_to_answer,client_id,reporting, 3
>percent_of_first_time_resolution,sales_revenue,sales_conversion_rates, 4
>cost_per_customer_acquisition,customer_satisfaction,qa,staff_retention,produc
>tiv ity, 5 sitel_revenue,gross_profit_margin) values 6
>(1,2,326,'A',3,4,5,6,b,'7',8,9,10,11); insert into kpi_period * ERROR at line
>1: ORA-00972: identifier is too long
>
>From Oracle documentation I see this:
>
>ORA-00972 identifier is too long
>Cause: The name of a schema object exceeds 30 characters. Schema objects are
>tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
>Action: Shorten the name to 30 characters or less.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun May 09 1999 - 23:07:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US