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

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

In this article, I will explain what the PSP (Parameter Sensitive Plan Optimization) feature is. I would like to point out that this feature will …

In today’s article, I will be explaining where we can download Pgadmin and How to Install it. Multiple tools are used to connect to PostgreSQL. …

In this article, I will talk about how to recover accidentally drop, truncate or deleted table in Production database by using flashback in standby database. …

In today’s article, we will be learning about Oracle Data Pump Architecture. It has 4 important components. -expdp (export data pump) -impdp (import data pump) …

In today’s article, we will talk about ORA 12638 credential retrieval failed tips. For the solution, we need to make the following change in sqlnet.ora …