Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00972: identifier is too long

Cac47Jul 30 2009 — edited Jul 30 2009
Hello,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2009
Added on Jul 30 2009
2 comments
3,777 views