Grokbase › Groups › Oracle › oracle-l › March 2003
FAQ
The question from Janardhana Babu Donga yesterday about how to recreate a
dropped package/procedure/function made me think about something else.
Imagine the following scenario:

There is some commercial off-the-shelf (COTS) software package running
against my database. The software package uses sequences. Someone drops a
sequence by mistake and later on jobs start failing right and left. I don't
know exactly how the sequence is used so I don't know what start value to
create it with if I did recreate it myself.
I guess I would have to do a point-in-time recovery in another location
until just before the sequence was dropped, but that seems like a lot of
work for just a sequence. Are there any more clever ways?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Daniel W. Fink at Mar 26, 2003 at 9:59 pm ⇧
    Jacques,

    If you know the field that is being populated by the sequence,
    examine the last 25/50 entries, determine the pattern and 'high' value,
    then recreate the sequence accordingly.

    If you don't know the field, you can take a guess that it is the
    primary key (or perhaps another unique value).

    --
    Daniel W. Fink
    http://www.optimaldba.com

    IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
    Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
    Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

    Jacques Kilchoer wrote:
    The question from Janardhana Babu Donga yesterday about how to
    recreate a dropped package/procedure/function made me think about
    something else. Imagine the following scenario:

    There is some commercial off-the-shelf (COTS) software package running
    against my database. The software package uses sequences. Someone
    drops a sequence by mistake and later on jobs start failing right and
    left. I don't know exactly how the sequence is used so I don't know
    what start value to create it with if I did recreate it myself.

    I guess I would have to do a point-in-time recovery in another
    location until just before the sequence was dropped, but that seems
    like a lot of work for just a sequence. Are there any more clever ways
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Daniel W. Fink
    INET: optimaldba_at_yahoo.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Jacques Kilchoer at Mar 26, 2003 at 10:59 pm ⇧
    That would work if
    a) I knew that the sequence was being used to create values for a column in
    a table, and
    b) it was only used for that purpose.
    Which is obviously not always the case.
    Another list member suggested to me that I use LogMiner to look for changes
    in sys.seq$. I will try that.

    -----Original Message-----

    If you know the field that is being populated by the sequence, examine
    the last 25/50 entries, determine the pattern and 'high' value, then
    recreate the sequence accordingly.

    If you don't know the field, you can take a guess that it is the primary
    key (or perhaps another unique value).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Jacques Kilchoer
    INET: Jacques.Kilchoer_at_quest.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 26, '03 at 8:33p
activeMar 26, '03 at 10:59p
posts3
users2
websiteoracle.com

2 users in discussion

Jacques Kilchoer: 2 posts Daniel W. Fink: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase