Re: Importing sql server 7/2000 database to Oracle

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)