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

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-63d83816b28c9130467233/] 2. …

The following error is received when running the datapump with the file size parameter. ERROR : [crayon-63d83816b2cbb493938935/] 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-63d83816b363b364883903/] 2. Export: [crayon-63d83816b3644312899297/] 3. Dump file size estimation: [crayon-63d83816b3646421187795/] 4. Remap schema: [crayon-63d83816b3648514628005/] …

While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. [crayon-63d83816b3ce5139504282/] 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 …

In this article, I will explain how to connect to the postgresql database via pgadmin. First of all, in order to connect to postgresql, you …

We can create a new “Database Directory” without using existing database directories in the database. [crayon-63d83816b4340017337811/] We can view the directories that exist in the …

The reason we got this error is because the large file tablespace can contain only one data file. ERROR : ORA-32774: More Than One File …