Re: SUBSTR "feature"

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 May 1999 20:34:20 +0100
Message-ID: <927056259.7232.0.nnrp-01.9e984b29@news.demon.co.uk>

An interesting point about reset on the sessionid. I haven't tried it, but since the session id (audsid) is generated from a sequence owned by SYS (named something like audsess$) it might be possible to reset the session id in the same way that you reset and sequence.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Steven Whatley wrote in message <927054656.654781_at_news.blkbox.com>...

>seems that somehow over the weekend either converting the database to
>UNICODE or something reset the SESSIONID sequence. We asked Oracle a
>while back how to reset it and they said it couldn't be done. But, I
>degress.
Received on Tue May 18 1999 - 14:34:20 CDT