Re: Sqlplus formatting error
- From: "fitzjarrell@xxxxxxx" <fitzjarrell@xxxxxxx>
- Date: 4 May 2007 08:29:53 -0700
Comments embedded.
On May 4, 10:21 am, andre...@xxxxxxxxxx wrote:
I am running the following script from my Windows client:
w.sql:
select substr(host_name,1,15) host, substr(instance_name,1,10)
instance, substr(global_name,1,10) DB_name,
version, substr(user,1,10) username from v$instance, dual,
global_name;
Result:
This is your first session.
SQL> connect w/w@test
Connected.
SQL> @w;
HOST INSTANCE DB_NAME VERSION
USERNAME
--------------- ---------- ---------- -----------------
----------
sm1tordat201 test TEST 9.2.0.7.0
W
This is NOT the same session as you've connected to another database
and have invoked a possibly different glogin.sql.
SQL> connect system/sebsystem@seblps;
Connected.
SQL> @w;
HOST
------------------------------------------------------------
INSTANCE
----------------------------------------
DB_NAME
VERSION
----------------------------------------
-----------------
USERNAME
----------------------------------------
sm1tordat201
SEBLPS
SEBLPS
9.2.0.7.0
SYSTEM
SQL> quit
In the first instance test, the output are formatted correctly. In the
second instance seblps, the columns are not trimming. Does anyone know
what's causing this? Since I'm running them both from the same Sqlplus
session, it can't be the sqlplus settings.
This is not correct, as explained above.
SELBPS and TEST both reside
on the same unix box so the unix environment is the same. The only
thing I can think on is the server parmeters are different but I can't
find out which one.
You would need to do this from each connection:
connect w/w@test
spool test_sqlplus_parms.lst
show all
spool off
@w
connect system/sebsystem@seblps
spool seblps_sqlplus_parms.lst
show all
spool off
@w
You could then check the spool files for differences.
David Fitzjarrell
.
- References:
- Sqlplus formatting error
- From: andrewa1
- Sqlplus formatting error
- Prev by Date: Re: 10gR2 RAC install... Checking existence of VIP Node application -- failed
- Next by Date: Re: Fastest way to ASCII file or other ideas?
- Previous by thread: Sqlplus formatting error
- Next by thread: Re: Sqlplus formatting error
- Index(es):
Relevant Pages
|
