Posted by Mir Sayeed Hassan on 9th October 2017
How to export table level by using expdp Consider the below example tested in our test env & verified Create the directory at OS Level to place the backup of the dumpfile [oracle@testdb backup]$ mkdir db_dump_bkp [root@testdb backup]# chmod… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export table level by using expdp
Posted by Mir Sayeed Hassan on 2nd October 2017
Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4) Export on 12c (12.1.0.2) – Tested in our env : 10.20.0.82 SQL> select instance_name,version from v$instance; INSTANCE_NAME VERSION —————- —————– … Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)
Posted by Mir Sayeed Hassan on 2nd October 2017
Perform the expdp (fulldb/schema/table) by using the ASM Storage Step 1 – Create the Directory in ASM location (Example – +DATA/mir_exp) [grid@asmdb ~]$ asmcmd ASMCMD> ls CRS/ DATA/ FRA/ ASMCMD> cd DATA ASMCMD> mkdir mir_exp ASMCMD>… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on Perform the expdp (fulldb/schema/table) by using the ASM Storage