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