RE: Find the table's name that using sequences

Oh yeah. I forgot about that LONG data type pain in the anus when you are looking for something. I just attended 9i new features in Colorado Springs last week. I asked, with all these new features, why the implementation of the LONG data type was still so piss poor (well, maybe not exactly in those terms, but that sentiment). I didn't get any answer. But the weather there was lovely. No humidity at all (unlike the steam bath here in Tulsa). It was bone dry, but that's their problem. I enjoyed the weather before heading back to green grass and night air filled with lighting bugs, the ratcheting sound of cicadas, and humidity ... lots and lots of humidity ... hot humidity. Click your heals together three times and repeat after me: At least you don't live in Houston. At least you don't live ...

Yet another long shot is to go plowing through V$SQL or V$SQLTEXT_WITH_NEWLINES which gets my vote for world's worst view. When a view makes me say screw it and resort to a GUI, then that's BAD.

If all of this searching produces nothing, I suppose you can periodically check the value of the sequence to see if it is going up.

Maybe note the current value of the sequence and grants on it, then drop it to see if anything goes invalid?? (or if anyone hollers) Are we feeling bold and daring?

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Sent: Wednesday, July 16, 2003 7:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Find the table's name that using sequences
>
>
> That won't catch sequences in triggers.
>
> You can't easily find sequence use in a trigger either, as
> the code is stored in a LONG.
>
> Best to dump to a text file and use grep.
>
> And if your programmers practice safe sequences, it will be
> in their code instead of the database anyway.
>
> Although if they're *really* good, it will be in a package, and
> it *will* show up in dba_source.
>
> Jared
>
>
>
>
>
> Stephen Lee <Stephen.Lee_at_DTAG.Com>
> Sent by: ml-errors_at_fatcity.com
> 07/16/2003 02:14 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Find the table's name that using sequences
>
>
>
> A mad rampage through DBA_SOURCE might reveal something useful.
> Something like:
> select name,text from dba_source where upper(text) like
> '%SEQUENCE_NAME%';
>
> And do the same with TRIGGER_BODY from DBA_TRIGGERS.
>
> -----Original Message-----
> --------------------------------------------------------------
> --------------
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> >>> mitchell.lee_at_rogers.com 07/16/03 03:09PM >>>
> Hi All
>
> At first I thought it is easy to find those tables to use
> sequences but I
> failed. dba_sequence don't give too much info. Is there any idea?
>
> Thanks in advance
> Mitchell
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: Stephen.Lee_at_DTAG.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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.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
Received on Wed Jul 16 2003 - 21:28:07 CDT