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 …
Read More »ORA-01000: Maximum Open Cursors Exceeded
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-662a14b69e8b1068698646/] …
Read More »PostgreSQL Local Database
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 …
Read More »Oracle List Contents Of Dump File
With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-662a14b69f050477647452/] Afterwards, you can see which commands are available by …
Read More »ORA-00020: Maximum Number Of Processes Exceeded
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 …
Read More »PSQL Create Database With Template
When creating new projects and new databases, we can use the template0 database instead of writing one by one. Example: [crayon-662a14b69f39d260805373/] We can create it …
Read More »Dump File Size Estimation
In today’s article we will learn how to use the Estimate_only parameter for Dump File Size Estimation. [crayon-662a14b69f60b892344020/]
Read More »Create PostgreSQL Database
There are multiple methods and parameters when creating a database. I will talk about them in this article. There are 4 methods to create the …
Read More »Interactive Command Line
While the Export or Import process is in progress, we can switch to the interactive command line mode with Ctrl+C from the keyboard. We can …
Read More »ORA-39358
I got this error while importing dump file: ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0 . SOLUTION: First we check …
Read More »