Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> export utility and reset of sequences
Hi!
I got a question: I exported a user schema using the export tool and was importing the data into a new database.
It seems that the sequence definitions got exported, but when importing the dump file, the sequences get recreated in the new db (and therefore start counting from 1 again).
Is there a way that I could retain the value of the sequence before taking the export?
Thanks, Received on Thu Oct 26 2000 - 16:46:50 CDT
![]() |
![]() |