topic Re: table name restriction in Operating System - HP-UX

table name restriction

malay boy — Tue, 28 Oct 2003 01:17:12 GMT

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

regards
mB

Re: table name restriction

Stan_17 — Tue, 28 Oct 2003 01:25:52 GMT

Still 30!

-
Stan

Re: table name restriction

malay boy — Tue, 28 Oct 2003 01:36:59 GMT

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

Re: table name restriction

Yogeeraj_1 — Tue, 28 Oct 2003 02:16:11 GMT

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

Re: table name restriction

malay boy — Tue, 28 Oct 2003 02:35:44 GMT

Yogeraj,
You are right ..