How are you assigning the sequence - a trigger?

<<MrO>>

----- Original Message -----
From: "Rajavardhan "
<oracledba-ezmlmshield-x62439058.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, August 31, 2007 12:18 AM
Subject: importing data from exported file sequence values


>
>
>
>
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page