Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me




  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for June, 2019

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB

Posted by Mir Sayeed Hassan on 25th June 2019

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB Connect to the CDB Database Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target / Example: rman target sys/******@ora18c or rman target /  – The result will be same Connect… Read more..

Posted in RMAN | Comments Off on RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB

How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME    STATUS        VERSION —————————————— ora18c           OPEN         18.0.0.0.0 Check… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c

How to export the Pluggable full DB using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export the Pluggable full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME STATUS VERSION —————- ————————————— ora18c OPEN 18.0.0.0.0 Check the number of PDB’S exist in CDB [oracle@oracle18cdb… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Pluggable full DB using expdp utility in Oracle 18c

How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c

Posted by Mir Sayeed Hassan on 23rd June 2019

How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME   STATUS       VERSION ——————————————————— ora18c          OPEN         18.0.0.0.0 Create… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c