Hi



Dba gurus



I have imported tables from exported file when I imported

From exported file

there are sequences used In the database

when import the data the sequences' it is incrementing from current values



example



when I created the sequence minvalue is 1



then I have inserted 20 records my currentval is 20



next I exported and imported into another system



now the value is 21 ,20,.....40



how can stop increment like this



I want sequence ids 1,2,3,4,....20 instead of 20,21,22,23



Plz help me









Thanks & Regards



V.Rajavardhan Reddy

Database Administator

GSS America Infotech Ltd.

Block B, 3'rd Floor,

Cyber Gateway,

Hi-Tech City,

Hyderabad.

Tel:- 040-40028700

Fax:- 040-40028703

Visit us: http://www.gssamerica.com




Oracle LazyDBA home page