ORACLE

In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-6a83d1d3efe66073514466/] 2. Export: [crayon-6a83d1d3efe73860732607/] 3. Dump file size estimation: [crayon-6a83d1d3efe75368129497/] 4. Remap schema: [crayon-6a83d1d3efe77769927171/] …

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

We can create a new “Database Directory” without using existing database directories in the database. [crayon-6a83d1d3f0b44035403335/] 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 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 …

In today’s article, I will share the solution of the error given below when the delete obsolete command is run. Error: [crayon-6a83d1d3f15e9813202163/] Before deleting crosscheck …

In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [crayon-6a83d1d3f1b04120945419/] (PRIMARY_2) [crayon-6a83d1d3f1b0d899014803/] …

If you get this error while operating on a table on Oracle Database, it means that the table is being used by someone else. Error: …