| ORA-00972 [message #70885] |
Wed, 07 August 2002 11:19  |
Deryk Marien
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
I am trying to port over this SQL statement to run under Oracle, but I get the error ORA-00972: identifier is too long.
Can anyone help and shed some light on this?
SELECT SSUITE_RV_EMPLOYEE_TAX_INFORMATION.TAX_TYPE,
SSUITE_CS_EMPLOYEE.EMPLOYEE_ID,
SSUITE_CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM,
SSUITE_CS_EMPLOYEE.SOCIAL_SECURITY_NUMBER,
SSUITE_RV_EMPLOYEE_NAME.FIRST_NAME, SSUITE_RV_EMPLOYEE_NAME.LAST_NAME,
SSUITE_RV_EMPLOYEE_TAX_INFORMATION.EXEMPTION_NBR,
SSUITE_RV_EMPLOYEE_TAX_INFORMATION.FILING_STATUS
FROM (SSUITE_CS_EMPLOYEE LEFT JOIN SSUITE_RV_EMPLOYEE_TAX_INFORMATION
ON
SSUITE_CS_EMPLOYEE.EMPLOYEE_ID =
SSUITE_RV_EMPLOYEE_TAX_INFORMATION.EMPLOYEE_CORPORATION_ID) INNER JOIN
SSUITE_RV_EMPLOYEE_NAME ON SSUITE_CS_EMPLOYEE.EMPLOYEE_ID =
SSUITE_RV_EMPLOYEE_NAME.EMPLOYEE_ID
WHERE (SSUITE_RV_EMPLOYEE_TAX_INFORMATION.TAX_TYPE Is Not Null AND
SSUITE_CS_EMPLOYEE.EMPLOYEE_ID Is Not Null AND
SSUITE_CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM="WORK" Or
SSUITE_CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM="PAVL" Or
SSUITE_CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM="NEW" Or
SSUITE_CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM="AVAL")
ORDER BY SSUITE_CS_EMPLOYEE.EMPLOYEE_ID;
|
|
|
|
|
|
| Re: ORA-00972 [message #71655 is a reply to message #70885] |
Wed, 11 December 2002 09:59  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
check the below..
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.
In your case, the table name is too lengthy. (more than 30 characters)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
