Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> export utility and reset of sequences

export utility and reset of sequences

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Thu, 26 Oct 2000 14:46:50 -0700
Message-Id: <10661.120360@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US