Recent Posts

February, 2020

  • 29 February

    IIS Enabling and configuration on Web Server

    Hey SQL Enthusiastic, this is for SQL Users and technology Enthusiastic today I am sharing the Experience where we have installed and Configured the IIS Feature on Web Server: Step …

    Read More »
    • 28 February

      Grant Privileges

      You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL.   GRANT SELECT ANY CUBE TO …

      Read More »
      • 28 February

        Revoke Privileges

        REVOKE

        The privileges to revoke.   REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table  FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ;  

        Read More »
        • 28 February

          Archivelog mod değiştirme

          Sysdba kullanıcısı ile sqlplus girişi yapılır. [oracle@baranyildiz ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 12 22:02:41 2019 Copyright (c) 1982, 2014, Oracle.  All rights reserved. …

          Read More »
          • 28 February

            ORA-00059: maximum no. of DB_FILES exceeded

            ORA-00059: maximum number of DB_FILES exceeded   While adding a new datafile to tablespace, I got the ” ORA-00059: maximum no. of DB_FILES exceeded ” error, then I checked db_files …

            Read More »