ORACLE

  It is possible to find the privileges granted to a user with the data dictionary views. The main views that can be used are …

  We can set a parameter in the Oracle database to its default value. The reset process is only performed in the spfile. The parameter …

  During the insert operation to the tables, ORA-600 [ktspfhsp-9] error is received due to various bugs and corruption in the segments of the table. …

  Partitioned table cannot be moved like a normal table. Therefore, partitions need to be moved separately. In order to prevent the table from creating …

  During the drop operation of the event records on the Exadata cell node, when we try to delete individual records created for the problem, …

  Events that are automatically recorded when a problem occurs on the Exadata cell node must be cleared when the problem is corrected. The cleaning …

  After installing Oracle clusterware, we often ask the following question. What is my Oracle Cluster Name? In RAC systems, we can query the cluster …

  When a table containing a CLOB column is queried with a dblink from a remote database, it returns an error as ORA-22992. A table …

  In some cases, we may need to move the lob columns in a table to another tablespace. You can do this with the following …

  When access to the KVM switch in the Exadata cabinet, a “Network connect error” error can be received from Java. An error may occur …