Re: max value for naming

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: Sat, 14 Nov 1998 15:23:03 +0800
Message-ID: <72jk0q$s8i$2@news.seed.net.tw>

hpcheong_at_ncs.com.sg ¼¶¼g©ó¤å³¹ <72gucm$n72$1_at_nnrp1.dejanews.com>...
>hi
>
>can anyone tell me what is the max number of char for naming a table's
name,
>tablespace's name and instance's name. is there any differrent in the
>version, if yes, i would like to know the differences. thanks in advance!!

Object names are limited to 30 characters, with exceptions:

    Database Name: 8 characters,
    Database Link: 128 characters.
    Some objects names are recommended to less than 30 characters, since Oracle will prefix the names.

(for example, snapshot names are recommended to 23 characters.) Received on Sat Nov 14 1998 - 01:23:03 CST