Re: Oracle 10g Table Name limit

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 25 May 2006 07:46:15 -0400
Message-ID: <c7idnfrAx8CaBOjZRVn-vg@comcast.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:6mea72p2kekked7g455oci4ip9p26toiaq_at_4ax.com...
: On 24 May 2006 19:48:26 -0700, rsundararajan_at_gmail.com wrote:
:
: >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
:
:
: Just type
: desc user_tables
:
: and you'll know
:
: --
: Sybrand Bakker, Senior Oracle DBA

it's interesting to look at USER_OBJECTS. kinda gives the impression that 128c might be possible one day -- but looking at the underlying view definition shows that OBJ$ limits all object names to 30c (including some of the relatively newer ones), but is UNIONed to LINK$ to include db links -- which can be up to 128c

(still wondering why that 30c limit persists)

++ mcs Received on Thu May 25 2006 - 06:46:15 CDT