Interview Question in SQL Server Clustering


 

Interview Question :: Error in running this sql command


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 . . .
Answers to "Error in running this sql command"
RE: Error in running this sql command?

Why do you want such long names for tables. A small and meaningful name is more easy to access.
 
Vote for this answer ::  
RE: Error in running this sql command?

sql is unable to handle string...

AITEC_TB_RADIALEQUILIBRIUM_MIG... . . .)



Too long identifier ie string

use small string ..........
 
Vote for this answer ::  
RE: Error in running this sql command?

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

go for simple why complicated name...............
 
Vote for this answer ::  
Update Alert Setting