This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two …
Read More »How To Restore Encrypted Backup To Another Instance On SQL Server
First you should restore your certificate to this instance. You can restore your certificate with the help of following script. You must write the …
Read More »Encrypted Backup On SQL Server
You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …
Read More »The Select permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’
When you see an error, such as in the following screenshot, you may consider why your database is trying to access a hidden system …
Read More »Oracle_fdw oracle_utils.c:22:17: fatal error: oci.h: No such file or directory
When you run the make command when installing Oracle_fdw, you may encounter the error as follows. The reason for this error is that the …
Read More »How To Move Table To Another Tablespace
In this article, I will show you how to move a table to another tablespace. Actually it is very simple to move table with …
Read More »How To Install utl_mail and Configure smtp
You need the utl_mail package to send e-mail from the database. To use this package, the smtp_out_server parameter must be set. Also, “network acl” …
Read More »How To Split SQL Server Backup Files To Different Disks
If you are not using any backup software, you may not be able to back up large databases to a single disk. In such …
Read More »How To Detect Queries That Do Not Use Bind Variable
For the database, the use of bind variables in queries is quite important. The hard parsing process in the database will increase when bind …
Read More »How To Backup All Databases On an Instance On SQL Server
You can backup all databases on an Instance with the help of the following script (except tempdb) You should write the path you want …
Read More »