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 »/bin/rm: Argument list too long. Error for deletion of Audit files
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 …
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 »PostgreSQL Streaming Replication
Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“ [crayon-676a201273bfb113284848/] 2. Configuration Changes in file “pg_hba.conf” Make an entry …
Read More »