Re: What is the meaning of # and $ characters in database object names?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 04 Oct 2006 20:00:54 +0200
Message-ID: <eg0shc$mi0$2@news3.zwoll1.ov.home.nl>

Cris d'l'Eiretto schreef:
> sybrandb wrote:
>

>>> Anyone else remember IOR C?
>>
>>
>> Oh sure.
>> And IOR W
>> And above all IOR I

>
> IOR was still there in Oracle 5, IIRC.
>

It still lurks: from 9.2:

create cluster c_obj# (obj# number)

   pctfree 5 size 800                           /* don't waste too much 

space */

   /* A table of 32 cols, 2 index, 2 col per index requires about 2K.
    * A table of 10 cols, 2 index, 2 col per index requires about 750.
    */

   storage (initial 130K next 200k maxextents unlimited pctincrease 0)    /* avoid space management during IOR I */ /

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Oct 04 2006 - 13:00:54 CDT