Re: Oracle 10g Table Name limit

<rsundararajan_at_gmail.com> wrote in message news:1148525306.664275.141140_at_i40g2000cwc.googlegroups.com...
> Hi,
>
> I think till 9i the limit for the number of characters for a table name
> was 30 characters. I couldnt find how much it is for 10g. Could any
> of you help me??
>
> Thanks in advance,
> Sundar
>

I believe it is the same 30 characters. You could try it. create table a23456789012345678901234567890(

    acol number);

probably works and
create table a234567890123456789012345678901(

    acol number);

probably fails.
Jim Received on Wed May 24 2006 - 21:54:26 CDT