In today’s post, we will cover How to Use Flashback during Export. [crayon-676c65fc6aed3596784473/] [crayon-676c65fc6aedb003879294/] This value is found as follows; [crayon-676c65fc6aedd720614296/]
Read More »ORACLE
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-676c65fc6b9b3864144918/]
Read More »Parallel Export
In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-676c65fc6be0e340927105/] 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-676c65fc6bfb3617623505/]
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-676c65fc6cc3c788387501/]
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-676c65fc6cf4c634535089/]
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-676c65fc6d212227668836/]
Read More »PostgreSQL GENERATED ALWAYS And SERIAL
In today’s article, I will explain the difference between PostgreSQL GENERATED ALWAYS and SERIAL. The serial data type is one of the previously used data …
Read More »Data Pump Export Parallel
The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports. [crayon-676c65fc6d8b6676470829/] We can also …
Read More »