Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server 2000 Migrate to Oracle

Re: SQL Server 2000 Migrate to Oracle

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 29 Nov 2004 21:08:29 -0000
Message-ID: <41ab8fbf$0$16576$cc9e4d1f@news-text.dial.pipex.com>


"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.com 
Received on Mon Nov 29 2004 - 15:08:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US