cancel
Showing results for 
Search instead for 
Did you mean: 

table name restriction

SOLVED
Go to solution
malay boy
Trusted Contributor

table name restriction

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

regards
mB
There are three person in my team-Me ,myself and I.
4 REPLIES
Stan_17
Valued Contributor
Solution

Re: table name restriction

Still 30!

-
Stan
malay boy
Trusted Contributor

Re: table name restriction

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
There are three person in my team-Me ,myself and I.
Yogeeraj_1
Honored Contributor

Re: table name restriction

hi,
you could also have see it by doing a:
desc dba_tables
or
desc user_tables
-
column table_name
-
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
malay boy
Trusted Contributor

Re: table name restriction

Yogeraj,
You are right ..
There are three person in my team-Me ,myself and I.