Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: I cant insert
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
![]() |
![]() |