Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »dbtut
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 »Setting the Database AUTO_CLOSE Option to OFF to Improve Performance
Auto_Close is an option of the database. If set to ON, the database is opened and closed each connection. The procedure cache is cleared …
Read More »@@VERSION, SERVERPROPERTY and @@MAX_CONNECTIONS Functions in SQL Server(TSQL)
The maximum number of connections that an instance can accept varies by version. With the @@MAX_CONNECTIONS function, we can query the number of default maximum …
Read More »How To Move OCR and Vote Disks to Different ASM Disk Groups
Generally, for the Oracle Cluster Registry and Vote Disks, the disk group where the database files are stored is used in RAC Systems. The …
Read More »Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail
You can receive this error even if you configure Database Mail and activate it via sp_configure. You can reach details in my article “How …
Read More »SET LOCK_TIMEOUT and @@LOCK_TIMEOUT Function in SQL Server(TSQL)
With SET LOCK_TIMEOUT, we can set the maximum amount of time a session will wait to access a blocked resource in milliseconds. If a …
Read More »How To Export SQL Server Table to CSV File
We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv …
Read More »ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline …
Read More »