Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backing up SEQUENCEs

Re: Backing up SEQUENCEs

From: John Darrah <jdarrah_at_veripost.net>
Date: Wed, 6 Mar 2002 00:45:42 +0000 (UTC)
Message-ID: <a87fa60beb3af3f5a50dea1fc06c11cd.36240@mygate.mailgate.org>


Could you go into greater detail as to the type of recovery you are doing? The only way I can see this happening is if you are transporting the tablespace
in from another database. The high watermark for all the sequences in the database are stored in a table called seq$. In any recovery scenerio besides transportable tablespace importation, the seq$ will be consistant with the rest of the database and you would not see duplicates.

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Mar 05 2002 - 18:45:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US