8 Replies Latest reply: Jul 9, 2013 5:03 PM by sybrand_b RSS

    How to display messages in Deutsch?

    user639304

      Hi,

       

      I use SQL*Plus, and I would want the messages to be displayed in German: for example, when I issue this:

       

      create table t(x number, y number);

       

      I would like to see the equivalent in German of "Table created".

      Here's what I tried in my SQL Plus:

       

       

      SQL> alter session set NLS_TERRITORY=GERMANY;

      Session altered.

      SQL> alter session set NLS_LANGUAGE=GERMAN;

      Session altered.

      SQL> create table t(x number, y number);

      Table created.

      SQL>

       

      As you see, I still have the message "Table created" after my alter session statements.

      Please, what should I do to get the messages displayed in German?

       

       

      Thanks.

       

       

       

      
      
      
        • 1. Re: How to display messages in Deutsch?
          JohnWatson

          Set your client's NLS_LANG variable:

           

          [oracle@oel58x64db121 ~]$

          [oracle@oel58x64db121 ~]$ export NLS_LANG=German

          [oracle@oel58x64db121 ~]$

          [oracle@oel58x64db121 ~]$ sqlplus scott/tiger

           

          SQL*Plus: Release 12.1.0.1.0 Production on So Jul 7 08:30:15 2013

           

          Copyright (c) 1982, 2013, Oracle.  All rights reserved.

           

          Last Successful login time: Di Jul 02 2013 18:19:49 +01:00

           

          Connected to:

          Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

          With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

           

          orclz> drop table t;

          drop table t

                     *

          ERROR at line 1:

          ORA-00942: Tabelle oder View nicht vorhanden

           

           

          orclz>

          • 2. Re: How to display messages in Deutsch?
            user639304

            Hi John,

             

            Thanks for your message. I have done what you have suggested, and I noticed the following:

            I obtain a message in German  when I want to drop a table  which doesn't exist, but when I execute a create table statement, the message is still displayed ( Table created ) in English. It seems like a message in German appears only when there is an error in the processing of a statement? Or is there something to do in order to have the equivalent in German of the message "Table created"?

            Here's what I have done:

             

            Microsoft Windows [version 6.1.7601]

            Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.

            C:\Users\RacDataguard>set NLS_LANG=German

            C:\Users\RacDataguard>sqlplus user1/user1

            SQL*Plus: Release 11.2.0.1.0 Production on So Jul 7 11:17:29 2013

            Copyright (c) 1982, 2010, Oracle.  All rights reserved.

            Connected to:

            Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

            SQL> drop table z;

            drop table z

                       *

            ERROR at line 1:

            ORA-00942: Tabelle oder View nicht vorhanden

            SQL> create table w( x number);

            Table created.

            SQL>

             

             

            Thanks.

            • 3. Re: How to display messages in Deutsch?
              1021994

              Pl set the Windows locale to Germany

               

              Configuring Oracle Database Globalization Support

               

              HTH
              Srini

              • 4. Re: How to display messages in Deutsch?
                user639304

                Hi Srini,

                 

                Thanks for your message.I have set my Windows locale to Germany, but  I still,in of Sql* Plus, have only error messages in German (the messages displayed after a successful processing of a statement are still in English).Is this the normal behavior of Sql* Plus?

                 

                Thanks

                 

                Ce message a été modifié par : user639304

                • 5. Re: How to display messages in Deutsch?
                  user639304

                  Hi,

                   

                  Could someone help me about my concern?

                   

                   

                  Thanks.

                  • 6. Re: How to display messages in Deutsch?
                    sybrand_b

                    What langiuages did you choose during installation of sql*plus?

                    By default only English is installed.

                     

                    ------------

                    Sybrand Bakker

                    Senior Oracle DBA

                    • 7. Re: How to display messages in Deutsch?
                      user639304

                      Hi Sybrand,

                       

                      Thanks for your message.

                      If I'm correct, sql * plus is installed when we install Oracle RDBMS Software, and I don't know if (and how) it's possible  during the RDBMS installation to choose languages. What is sure is that, during installation, no screen prompts me for the languages for SQL * Plus.    Would it be possible now to change the SQL * Plus language  from English to German?

                       

                      Thanks.

                      • 8. Re: How to display messages in Deutsch?
                        sybrand_b

                        Yes, it is possible to choose languages during installation. This copies the language specific message files (*.msb), right now you have files like oraus.msb, you should also have orade.msb

                        The languages you choose applies to all products including sql*plus.

                        If you don't have these languages, you need to reinstall Oracle in an existing home, and yes, this will work.

                        There is no other method. AFAIK, these files are not as stand-alone files on your installation media.

                         

                        Hth

                         

                        --------------

                        Sybrand Bakker

                        Senior Oracle DBA