Re: SQLPLUS - Unwanted Pause

"Dennis Taylor" <spammers_are_scum_at_ipipeline.net> wrote:

>
>
>Ron Strouss <rstrouss_at_ix.netcom.com> wrote in article
><338e0a9c.29678545_at_nntp.ix.netcom.com>...
>> We're trying to determine why logging on to one database pauses during
>> the execution of the glogin.sql script and others don't. We think it
>> has to do with a grant to an object owned by SYS, but we're not sure.
>>
>> We have a select statement on the v$database table to get the
>> database name which will be used as part of the user's SQLPLUS Prompt.
>>
>
>This may be way too obvious, but have you checked the SET PAUSE value ? It
>may be ON for one of the databases.
>
 

>> Dennis

It doesn't matter whether I 'set pause off' or not .... I set it to off, but I doesn't seem to matter.

We have about 6 other databases ... 7.1.4 and &.7.1.6 and none of rest have this problem.

!!! ??? !!!

Ron Received on Fri May 30 1997 - 00:00:00 CEST