another example, now I use sp1e.msb and sp2e.msb
Code:
oracle@simdes:/oracle/simp/sqlplus/mesg> echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1
oracle@simdes:/oracle/simp/sqlplus/mesg> export NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1
oracle@simdes:/oracle/simp/sqlplus/mesg> ls
cpye.msb cpyus.msb cpyus.msg sp1e.msb sp1us.msb sp1us.msg sp2e.msb sp2us.msb sp2us.msg
oracle@simdes:/oracle/simp/sqlplus/mesg> mkdir ../tmp
oracle@simdes:/oracle/simp/sqlplus/mesg> mv sp* ../tmp
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp1.msb not found
Error 6 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp1e.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp2.msb not found
Error 7 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp2e.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
SQL*Plus: Release 8.1.7.0.0 - Production on Jue May 16 12:32:14 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Conectado a:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
sys@DSIM>select sysdate from dual;
SYSDATE
--------
16/05/02
1 fila seleccionada.
sys@DSIM>quit
Desconectado de Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
oracle@simdes:/oracle/simp/sqlplus/mesg>
see I get spanish messages now and instead of putting sp1us.msb and sp2us.msb it works with sp1e* that is because I changed my NLS_LANG