Re: export/import and sequences

Hi;

sequences are not connected to tables, they are independent objects. If you yust export the table the sequence will not be included in the export file and will not be created at import.

If you export an entire user the sequence will be included in the export file and will be recreated with the correct starting value.

If you don't want to export the entire user you would have to manually create the sequence and set 'start with' to the correct value.

It would have been nice to be able to tell export exactly which objects to export (ie at the command line specifying objects=my_table,my_sequence) but unfortunally this is not the case.

Rgds
Steinar Heggelund

janet (janet_at_telesph.com) wrote:
: Hi gurus,
: i've checked dejanews but i don't see this exact topic
: covered. sorry for the newbie question.
 

: database 1:
: we have a table with a sequence. we export the table.
 

: database 2:
: we drop the table, we import it from above. (no special
: parameters)
 

: does the sequence get recreated?
: do the #'s on the 2 databases match? (this is what i really want)
: can i drop the sequence & not recreate it to make the #'s
: match?
 

: thanks
: janet
Received on Wed Mar 19 1997 - 00:00:00 CST