Database Administration (MOSC)

MOSC Banner

Getting 'ERROR at line 1: ORA-00972: identifier is too long' when executing 'alter table drop'

db is version 19.18 and compatible is 12.1.0.2. I'm executing the following.


SQL> ALTER TABLE FLEX_MAC DROP (PHARM_AFFIL_TYPE_CDE);

ALTER TABLE FLEX_MAC DROP (PHARM_AFFIL_TYPE_CDE)

*

ERROR at line 1:

ORA-00972: identifier is too long


Am I hitting a bug? I can't find information about this on Oracle Support.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center