Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  ERROR MESSAGE: “Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated. The statement has been terminated.”   EXPLANATION: …

  ERROR MESSAGE: Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.   EXPLANATION: You may experience …

  You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G. When we enable …

  If there is no open session using the database, you can change the name by pressing F2 while on the database. If there is …

  From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations …

  In this article we will import the image files in a folder into a table in the sql server database. First, we create the …

  With the data pump, you can use the query parameter to export only the records that are returned from the query in a table. …

  In the article “How to Transfer a Table From SQL Server To Excel“, I explained how to export our table from SQL Server to …

Description: Sometimes when we try to delete the large numbers of audit files, we get the error “/bin/rm: Argument list too long“. Solution : Run …

  If you have DBA privileges, you can connect with that user without knowing a user’s password, then you can set the old password. In …