Posted by Mir Sayeed Hassan on October 14th, 2017
How to connect Oracle 12c database (CDB and PDB)
[oracle@ora12c ~]$ !sq sqlplus / as sysdba
SQL> show con_name CON_NAME ------------------------------ CDB$ROOT
SQL> select...Read more..
Posted in Oracle 12C & 18C | Comments Off on How to connect Oracle 12c database (CDB and PDB)
Posted by Mir Sayeed Hassan on October 9th, 2017
[oracle@testdb backup]$ mkdir db_dump_bkp
[root@testdb backup]#...Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export partition table by using expdp
Posted by Mir Sayeed Hassan on October 9th, 2017
[oracle@testdb backup]$ mkdir db_dump_bkp
[root@testdb backup]# chmod -R 777 db_dump_bkp/
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export schema with compression method by using expdp
Posted by Mir Sayeed Hassan on October 9th, 2017
[oracle@testdb backup]$ mkdir db_dump_bkp
[root@testdb backup]# chmod -R 777 db_dump_bkp/
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export full database level by using expdp
Posted by Mir Sayeed Hassan on October 9th, 2017
[oracle@testdb backup]$ mkdir db_dump_bkp
[root@testdb backup]# chmod -R 777 db_dump_bkp/
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export schema level by using expdp
Posted by Mir Sayeed Hassan on October 9th, 2017
[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