Oracle

Oracle Tutorials

SQL Server

Exadata

Android

Recent Posts

February, 2020

  • 28 February

    Grant Privileges

    Image

    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

        Image

        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

          Image

          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 »
          • 27 February

            OGG-01161 Bad column index (40) specified for table TABLE_NAME, max columns = n

            Image

            Hi, Your Goldengate process may be abended with this error ” OGG-01161 Bad column index (40) specified for table TABLE_NAME, max columns = n ”  

            Read More »
            Powered by IT Tutorial | Designed by SysDBASoft IT
            IT Tutorial © Copyright 2026, All Rights Reserved