Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
What is a temporal table in SQL Server? We can store the history of inserts, updates and deletes by using temporal tables. Previously, we could …
Read More »
OPatch failed with error code 134
In opatch operations, if the corresponding home is not included in the ORACLE_HOME parameter, all opatch related commands cause 134 errors. To avoid this error, …
Read More »
ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server
We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. …
Read More »
How To Migrate From BasicFiles to SecureFiles
SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression …
Read More »
What tasks remain for the DBAs After Oracle Autonomous Database(19c)?
These are the tasks for which DBAs required in a database industry. Defining the database architecture Creating data models Integrating new data sources Tuning business …
Read More »
Oracle Autonomous Database Will Diminish DBAs Job? (Yes Or No)
Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade, and tune itself. It handles routine database maintenance tasks while the system …
Read More »
What is Natively Compiled Scalar User-Defined Function(Udf)?
We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …
Read More »
How To Export a Table Without Blob Column in Oracle
It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with …
Read More »
Generate In-Memory OLTP Migration Checklists(Objects in the Database is practicable to In-Memory OLTP?)
In this article, I will share What is Generate In-Memory OLTP Migration Checklists. If you want to learn What is In Memory OLTP and In-Memory …
Read More »
How To Check Undo Tablespace Usage in Oracle
Undo tablespace is extremely used during peak times. There is a possibility that some operations may be interrupted if you go uncontrolled. You should regularly …
Read More »