2 Replies Latest reply: Feb 11, 2013 2:55 PM by ***Anuj*** RSS

    DBA_USERS is not showing created date

    ***Anuj***
      I am not sure why dba_user is showing created as date mask

      SQL> select username,created,profile,password_versions from dba_users order by 2;

      USERNAME CREATED PROFILE PASSWORD
      ------------------------------ --------------------- ------------------------------ --------
      SYS dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      SYSTEM dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      OUTLN dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      DIP dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      ORACLE_OCM dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      DBSNMP dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
      APPQOSSYS dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G

      Any idea ?


      TIA
      Anuj