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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Can I recover sequence table??

Re: Can I recover sequence table??

From: Christian Hartmann <cha_at_christian-hartmann.de>
Date: Thu, 08 Mar 2001 18:33:53 GMT
Message-ID: <3aa7d060.355671@news.ewetel.net>

On Fri, 9 Mar 2001 01:41:52 +0900, ChoGS933_at_hananet.net wrote:

>If a system is crashed, can I recover sequence
>table. In other words, does Oracle recovers sequence table and it's sequence
>number?
>Please mail to me.... thank you.

Sequences are stored in the system-tablespace. Therefore a recovery of the system-tablespace will recover the sequences.

Ciao,

Christian Hartmann Received on Thu Mar 08 2001 - 12:33:53 CST

Original text of this message

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