Help: I cant insert

From: <yong321_at_yahoo.com>
Date: Wed, 05 May 1999 14:58:35 GMT
Message-ID: <7gpmao$jur$1@nnrp1.dejanews.com>

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 Wed May 05 1999 - 09:58:35 CDT