Hi:
With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and
added
set termout off
col site_name noprint new_value site_name_new
select 'SQL> ' site_name from dual;
selectuser
|| substr(proc.program, instr(proc.program,'@'),
instr(proc.program,' ')
by: [EMAIL PROTECTED]
10/29/2003 08:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: sqlplus prompt question in 9i
Hi:
With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/
:
[EMAIL PROTECTED]Subject: Re: sqlplus prompt question
in 9i
.com
I had same problem with 9i, what I did is at the begining of the
dbstarup or stop script, I mv the glogin.sql to _old, at end of scripts
I mv back to the original name.
Joan
Guang Mei wrote:
>
> Hi:
>
> With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and
> added
>
> se
Joan:
Thanks for the reply. This would work if dbstart is called when starting
instance. But if I do it manually (although not often I would say), I need
to remember this and do it by hand.
Also I think you only need to do it with dbstart script, not dbshut.
Guang
-Original Message-
Joa
Guang,
You don't need to do it manually, you just type what it prompt you, it will
connect to database without any problem. It had problem in crontab batch job
only.
Joan
Quoting Guang Mei <[EMAIL PROTECTED]>:
> Joan:
>
> Thanks for the reply. This would work if dbstart is called when starting
Title: RE: sqlplus prompt question in 9i
It could be your sql
Here is the prompt I have been using for a while with no problems at all
If the db is down you get a prompt of
Nolog>
set termout off
define new_prompt='nolog'
column value new_value new_prompt
selec
Title: RE: sqlplus prompt question in 9i
Thanks David!
That's exactly what I am looking
for.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of david hillSent:
Thursday, October 30, 2003 11:30 AMTo: Multiple recipients of list
O