5 Replies Latest reply: Nov 5, 2012 12:03 AM by Richa RSS

    SCN number showing unknown intigers

    Richa
      Hi,
      I was checking the scn number of both Primary and Standby database and got this value

      SQL> select current_scn from v$database;

      CURRENT_SCN
      5.9654E+12

      How to make is in correct format?
        • 1. Re: SCN number showing unknown intigers
          Hussein Sawwan-Oracle
          Richa wrote:
          Hi,
          I was checking the scn number of both Primary and Standby database and got this value

          SQL> select current_scn from v$database;

          CURRENT_SCN
          5.9654E+12

          How to make is in correct format?
          SQL> select current_scn from v$database;
          
          CURRENT_SCN
          -----------
           3.5255E+10
          
          SQL> SET NUMWIDTH 20
          SQL> /
          
                   CURRENT_SCN
          --------------------
                   35254650995
          http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm#SQPUG094

          Thanks,
          Hussein
          • 2. Re: SCN number showing unknown intigers
            teits
            Richa wrote:
            Hi,
            I was checking the scn number of both Primary and Standby database and got this value

            SQL> select current_scn from v$database;

            CURRENT_SCN
            5.9654E+12

            How to make is in correct format?
            i like to use this format:
            SQL> set numformat 99999999999999999999D99
            "COLUMN FORMAT settings take precedence over SET NUMFORMAT settings, which take precedence over SET NUMWIDTH settings"
            http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve013.htm#BABBDHHE

            HTH
            Tobi
            • 3. Re: SCN number showing unknown intigers
              Richa
              Hi,

              SQL> SET NUMWIDTH 20
              SQL> /

              CURRENT_SCN

              5965364972995.00



              SQL> set numformat 99999999999999999999D99
              SQL> select current_scn from v$database;

              CURRENT_SCN

              5965364972422.00

              In both cases the scn is showing with decimal points.
              How can make it normal
              • 4. Re: SCN number showing unknown intigers
                teits
                Richa wrote:
                Hi,

                SQL> SET NUMWIDTH 20
                SQL> /

                CURRENT_SCN

                5965364972995.00



                SQL> set numformat 99999999999999999999D99
                SQL> select current_scn from v$database;

                CURRENT_SCN

                5965364972422.00

                In both cases the scn is showing with decimal points.
                How can make it normal
                SQL> set numformat 99999999999999999999
                I think you can mark your thread as answered now.

                Tobi
                • 5. Re: SCN number showing unknown intigers
                  Richa
                  Thanks Hussein and Teits,
                  You always save my day :)