Oracle

Hi, I will explain How to Delete or Purge Audit Trail Table and Records in Oracle Database in this article.

Hi, Sometimes you may need changing Oracle ASM Diskgroup name.

Author     : Cihan Gedik Email        : [email protected] Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   Compatible Versions Weblogic 10.3.6 or Later Error Message weblogic.application.ModuleException: java.lang.OutOfMemoryError: GC overhead limit …

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 …

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

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. …

Hi, Sometimes you may need to install Oracle database silent or manually instead of GUI( Graphical User Interface ), or sometimes there is no GUI tool like VNC Server, so …

Author     : Cihan Gedik Email        : [email protected] Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/     Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users …

To start ADRCI in the interactive mode, type adrci at the command line, as shown here:

To determine the optimal value for the UNDO_RETENTION parameter, you must first calculate the actual amount of undo that the database is generating. Once you know approximately how much undo …