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 »
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 »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-63d49eda18798585788584/] 2. …
Read More »The following error is received when running the datapump with the file size parameter. ERROR : [crayon-63d49eda189de151770326/] SOLUTION : FILE SIZE parameter limits the size …
Read More »In today’s article, we will be learning DataPump Commands. 1. İmport: [crayon-63d49eda18dc0037242246/] 2. Export: [crayon-63d49eda18dc5350650451/] 3. Dump file size estimation: [crayon-63d49eda18dc7832839644/] 4. Remap schema: [crayon-63d49eda18dc9004785695/] …
Read More »While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. [crayon-63d49eda19389500147835/] SOLUTION : This error comes, when the user the user doesn’t have tablespace quota. 1.Check …
Read More »We can create a new “Database Directory” without using existing database directories in the database. [crayon-63d49eda198db489101904/] We can view the directories that exist in the …
Read More »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 …
Read More »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. …
Read More »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) …
Read More »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 …
Read More »