Re: import issue between 8i and 9i

Tom wrote:
> OK - not good to follow myself up here but i have figured it out i think
>
> It seems that there is actually quite a bit of activity on the database during the export and as the sequences are exported first
> the next value of the sequence is actually lower than the max value in the line. Therefore giving me this error from the
> application.
>
> now i just have to work out how to reset the sequence to a higher number than it currently is.
>
> thanks
>
>

select 'create sequence '||some_name||' start with ', max(value)||';' from <the table you want the sequence on> ;

Or take a consistent export

-- 
Regards, Frank van Bortel