Sequences in the databse not backed up
From: Bob Swerdlow <swerdlow_at_maine.rr.com>
Date: Mon, 04 Mar 2002 16:01:26 GMT
Message-ID: <qTMg8.2687$26.258343_at_typhoon.maine.rr.com>
Date: Mon, 04 Mar 2002 16:01:26 GMT
Message-ID: <qTMg8.2687$26.258343_at_typhoon.maine.rr.com>
We have ArchiveLog backups set up for our database and when we restore, all the tables in the tablespace are backed up fine. However, we use SEQUENCEs in the database, too, and they are not backed up. So, when we try to use the restored database, we get duplicate sequence numbers.
Is there a way to associate a sequence with a tablespace or is there a separate step needed to back them up?
Many Thanks,
-- Bob Swerdlow Chief Operating Officer Transpose, LLC rswerdlow_at_transpose.comReceived on Mon Mar 04 2002 - 17:01:26 CET