Re: Importing Sequences

From: Jill Proffitt <jproffitt_at_tznet.com>
Date: Wed, 8 Dec 1999 14:57:45 -0600
Message-ID: <bHz34.92280$7I4.2323600@news5.giganews.com>

I believe that if you export by user, instead by table, that it will handle a sequence. The last time I did a user export, it handled all of that user's objects, which included synonyms, trigger, etc. I don't remember if it included sequences or not.

A really awful solution would be to recreate the sequence, making sure you start at the last available sequence number. Its a thought, anyway. : )

Jill

Kevin Handley wrote in message <384E7A6D.33B79237_at_interaction-eng.com>...
>Is there anyway to import a sequence? I can import tables, but one table
>has a sequence associated with one column. When I use imp80 to import
>the tables I want to import, the sequence is not imported.
>
>Thanks,
>Kevin
Received on Wed Dec 08 1999 - 14:57:45 CST