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

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 …

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 …

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 …

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 …

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-6861b46cb7848855452930/] 2. …

The following error is received when running the datapump with the file size parameter. ERROR : [crayon-6861b46cb7a2a042111586/] SOLUTION : FILE SIZE parameter limits the size …

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 …

In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-6861b46cb8f89137240059/] 2. Export: [crayon-6861b46cb8f8e823869346/] 3. Dump file size estimation: [crayon-6861b46cb8f90001869333/] 4. Remap schema: [crayon-6861b46cb8f91223118824/] …

While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. [crayon-6861b46cb93cd752621113/] SOLUTION : This error comes, when the user the user doesn’t have tablespace quota. 1.Check …

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 …