Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …
Read More »Query the table with the Clob column from the remote database
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 »Cannot drop database because it is currently in use
If you want to delete the database, you will get this error if there is an open session on the database. First, set the …
Read More »DATALENGTH Function in SQL Server(TSQL)
With the DATALENGTH function, we can calculate the size of the data in a column in bytes. Usually, its useful for calculating the size of …
Read More »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 »No global profile is configured. Specify a profile name in the @profile_name parameter
With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail …
Read More »@@SPID Function in SQL Server(TSQL)
With the @@ SPID Function, we can find the session id of the current session. Usually we use when we want to exclude the …
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 »How To Find Total Size of All Databases in All Instance
Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes …
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 »