How to connect Oracle 12c database (CDB and PDB)  Container Database (CDB) Pluggable Database (PDB) [oracle@ora12c ~]$ !sq sqlplus / as sysdba SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> select… Read more..

How to export partition table 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]#… Read more..

How to export schema with compression method 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 -R 777 db_dump_bkp/ Create… Read more..

How to export full database 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 -R 777 db_dump_bkp/ Create… Read more..

How to export schema 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 -R 777 db_dump_bkp/ Create… Read more..

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..