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

We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …

In today’s article, How Can I See Invalid Object in Oracle Database? I will be answering the question. We can see with the help of …

In today’s article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs. In database operations, there are …

Instead of constantly writing our command and parameters for export/import operations, we can create a file containing our parameters and use this file in export/import …

This error can occur if the Oracle open_cursors parameter is too low or there is a coding issue where sql statements are not closed. [crayon-6484bda959739460442221/] …

In today’s article we will learn PostgreSQL Local Database Settings (LC_COLLATE, LC_CTYPE). First, What is Encoding? Let’s start with this. Encoding: Encoding is the character …

With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-6484bda959af0564449309/] Afterwards, you can see which commands are available by …

When i tried to connect to database, I got the ORA-00020: maximum number of processes (%s) exceeded error. Even from sysdba I was not able …

When creating new projects and new databases, we can use the template0 database instead of writing one by one. Example: [crayon-6484bda959e68084559447/] We can create it …

In today’s article we will learn how to use the Estimate_only parameter for Dump File Size Estimation. [crayon-6484bda95a033170700515/]