Re: SQLPLUS - Unwanted Pause
From: Dennis Taylor <spammers_are_scum_at_ipipeline.net>
Date: 1997/05/30
Message-ID: <01bc6d03$d232b800$0257c2cf_at_dennis>#1/1
Date: 1997/05/30
Message-ID: <01bc6d03$d232b800$0257c2cf_at_dennis>#1/1
[Quoted] 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. Received on Fri May 30 1997 - 00:00:00 CEST