Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server 2000 Migrate to Oracle
"DA Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1101709951.714111_at_yasure...
> HansF wrote:
>
>> Someone wrote:
>>
>>
>>>Just address the 30 character restriction and all is well. Simple as
>>>that.
>>>
>>
>>
>> I still would prefer someone address the 18 char tablename restriction.
>> Then have Oracle follow the resulting standard!
>>
>> /Hans
>
> SQL> desc obj$
> Name Null? Type
> ----------------------------------------- -------- ------------
> OBJ# NOT NULL NUMBER
> DATAOBJ# NUMBER
> OWNER# NOT NULL NUMBER
> NAME NOT NULL VARCHAR2(30)
>
> What am I missing?
It isn't ANSI SQL compliant which requires 18 character or less UPPER CASE identifiers. Hans wants the standard changed (upwards) and Oracle (and others) to comply with the new standard. I wish him luck.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Mon Nov 29 2004 - 15:08:29 CST