Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …

  Postgresql is one of the RDMS databases presented in simple form. Therefore, we need to install the extension to use dblink, Foreign Data Wrapper, …

  If you don’t use PG ADMIN or any other similar application and you want to see the data type in the columns of the …

SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …

A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …

  In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-662c79d6a86b3119801717/] [crayon-662c79d6a86b7690718027/] or [crayon-662c79d6a86b9664693565/] or [crayon-662c79d6a86ba546136771/] …

  In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-662c79d6a88b6408569529/] [crayon-662c79d6a88bb876560878/] [crayon-662c79d6a88bd758105369/] [crayon-662c79d6a88be882921927/] …

  Unplanned outages are very expensive, and the cost of downtime is rising as almost all mission critical systems are fully automated. Industries like banking …

  Pre-requites: Must have MySQL Enterprise Edition installed Download media file :  meb-4.1.0-el6.x86_64.rpm (For Linux Platform)   Installation of MySQL Enterprise Backup Command to install …

  Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …