Re: Export/export/sequence Oracle8

From: Richard Senior <news07_at_r-senior.demon.co.uk>
Date: Tue, 27 Jul 1999 22:50:31 GMT
Message-ID: <FFJws8.HHK@r-senior.demon.co.uk>

In article <7nl5bf$hnr$1_at_news.interpoint.ch>,

"Joel Brueziere" <joel.brueziere_at_urbanet.ch> writes:
> I must export a database (with a lot of data... and sequence)
> But I dont know if my sequence are safe after a export/import

They'll be fine. But don't take my word for it ...

Create a new user, connect as that user and create a sequence. Select the value from it a few times and make a note of the last value, then export the user. Drop the sequence and re-import, then try selecting from the sequence again.

N.B. If it jumped more than you expected, it was probably caching values. Use the NOCACHE option on the CREATE SEQUENCE command.

--
Regards,

Richard Senior
London, England Received on Tue Jul 27 1999 - 17:50:31 CDT