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

Home -> Community -> Usenet -> c.d.o.tools -> Re: migrating data from SQL 7.0 to ORACLE

Re: migrating data from SQL 7.0 to ORACLE

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Thu, 3 May 2001 13:47:00 +0200
Message-ID: <9crk4a$9t2$1@papyrus.erlm.siemens.de>

Dan Phillips <dphillips_at_instantforms.com> schrieb in im Newsbeitrag: ZRVH6.233841$Z2.2470161_at_nnrp1.uunet.ca...
> We are migrating our data tables from SQL 7.0 to Oracle and have run into
 a
> slight setback. The conversion process tells us that we are not allowed
 to
> have more than 1 column of type LONG in a table. Is ther a possible work
> around for this restriction.
>
> Also we had one column in the SQL 7.0 tables that was an identity
> column(auto-incrementing numeric column). We noticed that on the
 conversion
> to ORALCE the field was converted to a column of type NUMBER . Is there a
> method of creating a column that is and auto-incrementing column aside
 from
> ROWID?
>
> Thank you for any help.
>
> Regards,
> Dan
>
>
Received on Thu May 03 2001 - 06:47:00 CDT

Original text of this message

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