Re: Importing sql server 7/2000 database to Oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 24 Feb 2004 13:27:37 -0800
Message-ID: <1077658018.278075_at_yasure>


E Sullivan wrote:

> Thanks, Daniel. Yes, that is what I want. Now about the autonumbering
> columns: as long as we aren't going to add to the database and expect
> autonumbering, I can still have that column, right? That's what it sounds
> like.
>
> thanks again.

You can indeed. Just make the columns a NUMBER type as in:

CREATE TABLE t (
old_autonumbering_col NUMBER,
...);

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Feb 24 2004 - 22:27:37 CET

Original text of this message