ORA-00972: identifier is too long
Cac47Jul 30 2009 — edited Jul 30 2009Hello,
I've a litlle issue and I hope soemeone can help.
I'm running a recently migrated database on RH5.3 and Oracle Version is 10.2.0.4 Enterprise.
Old Version was 9.2.0.6.
After Migration, and all necessary check, Invalid Objects, Constraint, Data Integrity and so on everything was fine.
just during the import I got the Follwing Error :
IMP-00017: following statement failed with ORACLE error 972:
"GRANT SELECT ON "V$UPDATE_FORM" TO "R_IWS_READ""
IMP-00003: ORACLE error 972 encountered
ORA-00972: identifier is too long
And Now when Doing a Select on that View I get the same error Message.
IWS@cfmd > r
1 select * from iws.v$update_form
2*
select * from iws.v$update_form
*
ERROR at line 1:
ORA-00972: identifier is too long
Any Solutions? Did soemone suffer the same Issue?
Thxs for your Help.
Ca