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 October, 2018

ORACLE DBA – ACTIVITY CHECKLIST on DAILY/WEEKLY/MONTHLY/NIGHTLY

Posted by Mir Sayeed Hassan on 21st October 2018

ORACLE DBA – ACTIVITY CHECKLISTon DAILY/WEEKLY/MONTHLY/NIGHTLY Aim: This activity checklist is for Oracle DBA to perform the complete health check report of production databases on Daily/Weekly/Monthly basis as per the requirement. DAILY CHECKLIST

Posted in DBA Daily Activity | Comments Off on ORACLE DBA – ACTIVITY CHECKLIST on DAILY/WEEKLY/MONTHLY/NIGHTLY

How to reopen the expired db account without changing the password

Posted by Mir Sayeed Hassan on 13th October 2018

How to reopen the expired db account without changing the password Consider you have an expired db account & you need to recover this acccount at any cost as per your client request, Yes its possible to recover it, Find the below scenario tested in our env Create a test user in database & try Read More

Posted in Oracle SQL | Comments Off on How to reopen the expired db account without changing the password

How to export schema with Parallel method by using expdp

Posted by Mir Sayeed Hassan on 13th October 2018

How to export schema with Parallel method by using expdp [oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=expdp%U-`date ‘+%d%m%Y_%H%M%S’`.dmp logfile=expdp-`date ‘+%d%m%Y_%H%M%S’`.log schemas=mir PARALLEL=2 Export: Release 11.2.0.4.0 – Production on Sat Oct 13 15:25:00 2018 Copyright (c) 1982, 2011, Oracle and/or… Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on How to export schema with Parallel method by using expdp