Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 …
Read More »ORACLE
How To Move Lob Data in a Table To Another Tablespace
In some cases, we may need to move the lob columns in a table to another tablespace. You can do this with the following …
Read More »“Network connect error” error during Exadata KVM connection
When access to the KVM switch in the Exadata cabinet, a “Network connect error” error can be received from Java. An error may occur …
Read More »Oracle Automatic Storage Management -2
In this article I will continue to explain Oracle Automatic Storage Management. Before reading this article, I suggest you read the previous article. “Oracle Automatic …
Read More »Oracle Automatic Storage Management -1
In this article, I will explain the Automatic Storage Management (ASM) and ASM disk operations that come with the 10g version to the Oracle Database. …
Read More »Run commands from a single server on all cell nodes or compute nodes on Exadata(dcli utility)
You can run commands on all the compute nodes or cell nodes from a single server on Exadata. We can use the dcli utility …
Read More »How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State
Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be …
Read More »How To Move OCR and Vote Disks to Different ASM Disk Groups
Generally, for the Oracle Cluster Registry and Vote Disks, the disk group where the database files are stored is used in RAC Systems. The …
Read More »ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline …
Read More »How To Check if Oracle instance was started with pfile or spfile
We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value. If both the spfile and …
Read More »