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 »Database Administrator Job Description
Database Administrator (DBA) is the person or persons responsible for the control, maintenance, coordination and operation of the database management system. It is primarily responsible …
Read More »Connect To Postgresql Windows Command Line
In today’s article, I will explain how to connect to postgresql with the Windows command line. Before connecting with the Windows command line, we need …
Read More »Data Pump Jobs Kill
In today’s article, I will tell you how to Kill Data Pump Jobs in 3 steps. 1. First, Data Pump Jobs are listed. [crayon-676766bd5cdda663322140/] 2. …
Read More »ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate
The following error is received when running the datapump with the file size parameter. ERROR : [crayon-676766bd5cf42981412273/] SOLUTION : FILE SIZE parameter limits the size …
Read More »Install Dbeaver
In today’s article, I will explain how to install dbeaver and connect to the database. Dbeaever offers a free version of enteprise for students. If …
Read More »DataPump Commands
In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-676766bd5d1f8060235913/] 2. Export: [crayon-676766bd5d1fc939737925/] 3. Dump file size estimation: [crayon-676766bd5d1fd830262285/] 4. Remap schema: [crayon-676766bd5d1ff246285118/] …
Read More »ORA-01950: No Privileges On Tablespace
While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. [crayon-676766bd5d4af601126961/] SOLUTION : This error comes, when the user the user doesn’t have tablespace quota. 1.Check …
Read More »SQL Server Security
In this article, I will explain how to use and perform SQL Server security testing. Data is very important to everyone, but how safe is …
Read More »