Instead of rewriting the commands each time, we can use a parameter file to export/Import with Data Pump. 1. First we create the parameter file. …
Read More »ORACLE
ORA-01184: Logfile Already Exists
In today’s article, we will look at the cause of a possible error that we may receive if we want to add Redo Log on …
Read More »Oracle Remap Table
In today’s article, we will learn how we can create a Oracle Remap Table in three steps. 1. The table is exported from the first …
Read More »ORA-39070: Unable To Open The Log File
Today, I will be sharing with you the reasons for the ORA-39070 error we received on Oracle Database and how to solve it. Error; ORA-39070: …
Read More »Remap Schema
In some cases, it may be desirable to make a copy of an existing schema or to transfer a schema from one database to another. …
Read More »Most Used SQL Queries
In today’s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20). [crayon-6742ad0806572361301741/]
Read More »Oracle Export Flashback_Time
In today’s post, we will cover How to Use Flashback during Export. [crayon-6742ad08066ee898532922/] [crayon-6742ad08066f2615785867/] This value is found as follows; [crayon-6742ad08066f4730950100/]
Read More »Access Control in Oracle
In today’s article, we will learn how to see users who access Oracle Database or users who get an error while accessing. [crayon-6742ad0806856695784362/]
Read More »Parallel Export
In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-6742ad08069d3183211708/] Here; %u: Let the names of the Dump Files …
Read More »Who Are Using Temp Tablespace In Oracle
In today’s article, we will be learning Who Uses Temp Tablespace in Oracle Database. We can find out using the following code block. [crayon-6742ad0806b74689073539/]
Read More »