Re: SQL Server 2000 Migrate to Oracle

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 22:34:03 -0800
Message-ID: <1101709951.714111@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?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Nov 29 2004 - 00:34:03 CST