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 »ORACLE
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-6629088aa336f984840975/]
Read More »Oracle Export Flashback_Time
In today’s post, we will cover How to Use Flashback during Export. [crayon-6629088aa36f8315102401/] [crayon-6629088aa3703406809571/] This value is found as follows; [crayon-6629088aa3704421376258/]
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-6629088aa39b8280504644/]
Read More »Parallel Export
In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-6629088aa3bb5043220226/] 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-6629088aa3dec209127059/]
Read More »Oracle Data Pump Encryption
We use ENCRYPTION as Encryption parameter in Oracle Data Pump. We can use the ENCRYPTION parameter with the values ALL, DATA_ONLY, METADATA_ONLY and ENCRYPTED_COLUMNS_ONLY. [crayon-6629088aa3ff2952947948/]
Read More »Blocking Session In Oracle
In today’s article we will be learning How to See Block Session in Oracle Database. We can see the Block Session with the help of …
Read More »Data Pump Compression
Compression parameter in data pump is COMPRESSION. COMPRESSION parameter can be used with ALL, DATA_ONLY, METADATA_ONLY and NONE values. [crayon-6629088aa43b7499530753/]
Read More »Check Invalid Objects In Oracle
In today’s article we will learn How to See Invalid Object in Oracle Database. We can See Invalid Object using the following code block. [crayon-6629088aa4551590743813/]
Read More »