Error in running this sql command?

Question

If the name of a schema object exceeds 30 characters, I am getting an error 'identifier is too long'. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
Is there any settings to do in Oracle to allow schema name > 30 charecters.

Ex: I am getting error while trying to create a table like
sql>CREATE TABLE AITEC_TB_RADIALEQUILIBRIUM_MIG47_BC( . . .)

sql> Error: Identifier is too long . . .

Answer 1

Why do you want such long names for tables. A small and meaningful name is more easy to access.

Answer 2

i think no such settings are available........

go for simple why complicated name...............

Answer 3

sql is unable to handle string...

AITEC_TB_RADIALEQUILIBRIUM_MIG... . . .)



Too long identifier ie string

use small string ..........