In this article, I will explain the Automatic Storage Management (ASM) and ASM disk operations that come with the 10g version to the Oracle Database. …
Read More »SQL Server Logon Trigger
Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. …
Read More »SQL Server Cursor
Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …
Read More »@@SERVICENAME Function in SQL Server(TSQL)
You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you …
Read More »Run commands from a single server on all cell nodes or compute nodes on Exadata(dcli utility)
You can run commands on all the compute nodes or cell nodes from a single server on Exadata. We can use the dcli utility …
Read More »Set RegisterAllProvidersIP Value to 0 as Based on Availability Group
If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. …
Read More »The constraint ‘PK_X’ is being referenced by table ‘X’, foreign key constraint ‘FK_X’
If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When …
Read More »Could not drop object ” because it is referenced by a FOREIGN KEY constraint
When you try to delete the Primary table in tables that have a Primary Key Foreign Key relationship, you receive the error as follows. …
Read More »The INSERT statement conflicted with the FOREIGN KEY constraint
You can get this error when you want to inset data into a table that has the Foreing Key. It means that there is …
Read More »How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State
Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be …
Read More »