How To Check the Compatibility Level of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
ORA-39126 ORA-04063 Errors When Running expdp in Oracle 12c
The process is terminated as follows when running expdp in 12C databases. ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-04063:
Change Data Capture(CDC) in SQL Server
Change Data Capture (CDC) is a technology that can be used in incremental data transfers from OLTP systems to data
How To See Compilation Errors in sqlplus
When an object is incorrectly compiled, it is necessary to determine what this error is and to correct the error.
Backup Compression in SQL Server
The Backup Compression feature was introduced with SQL Server 2008. We can reduce our backup sizes by selecting this option
ORA-39142: incompatible version number 5.1
This error is received when trying to import a Data Pump export of the 12c r2 database to a lower
Compound Operators in SQL Server
With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable
Index Quality in Oracle Databases
Index quality is a factor that directly affects all database performance. The quality of an index is measured by the
User Defined Table Type and Table Valued Parameter in SQL Server
With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table
How To Change AWR Retention and Interval Values
If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about