Re: Importing Sequences

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 9 Dec 1999 13:49:54 GMT
Message-ID: <384FB382.E2182C7A@edcmail.cr.usgs.gov>

You can not import just a sequence the way you can import just one table. You either have to do a full import, or import the whole user's schema. Sequences are not tied to any one table. So importing a table will not import the sequence you are using for it. To me, the easiest was would be to recreate the sequence. You can query DBA_SEQUENCES to find out all the information you need to construct the DDL.

HTH,
Brian

Kevin Handley wrote:
>
> 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 Thu Dec 09 1999 - 07:49:54 CST