Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
If the view does not contain the object in another database, you only need to give the select authority on the view for the …
Read More »dbtut
How To Increase Incremental Backup Speed with Block Change Tracking
You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G. When we enable …
Read More »How To Change SQL Server Database Name
If there is no open session using the database, you can change the name by pressing F2 while on the database. If there is …
Read More »What is Network Access Control List and How To Use It
From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations …
Read More »How To Import Images To SQL Server with TSQL Codes
In this article we will import the image files in a folder into a table in the sql server database. First, we create the …
Read More »Oracle Data Pump Query Parameter
With the data pump, you can use the query parameter to export only the records that are returned from the query in a table. …
Read More »How To Import Excel To SQL Server 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 …
Read More »Connect With the Oracle User Whose Password You Don’t Know
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 …
Read More »How To Export SQL Server Table To Excel
I explained how to transfer data from SQL Server database to SQL Server database. In this article I will describe how to transfer from …
Read More »RMAN-06091: no channel allocated for maintenance
When we get the RMAN-06091 error during operations with RMAN, we need to open a new channel for maintenance. You can use the following command. …
Read More »