table name restriction

[malay boy]

Guru,
Simple question.What is the max lenght of table name for Oracle 9i?.

regards
mB

[Stan_17 · Accepted solution]

Still 30!

-
Stan

[malay boy]

Stan,
Bull eyes for you.Here are my testing with 31 character :


SQL> create table qwertyuiopasdfghjklzxcvbnmqwert(junk char(10));
create table qwertyuiopasdfghjklzxcvbnmqwert(junk char(10))
*
ERROR at line 1:
ORA-00972: identifier is too long

regards
mB

[Yogeeraj_1]

hi,
you could also have see it by doing a:
desc dba_tables
or
desc user_tables
-
column table_name
-
regards
Yogeeraj

[malay boy]

Yogeraj,
You are right ..