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

    Database Administrators

Archive for the 'Oracle SQL' Category

Next Entries »

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

Rename a schema in Oracle Database 11gR2

Posted by Mir Sayeed Hassan on 15th September 2018

Rename a schema in Oracle Database 11gR2 Find the schema name to rename with user# SQL> select user#,NAME from SYS.user$ WHERE NAME=’TEST’; USER# NAME ———- —————————— 208 MIR Now modify the schema name “MIR” to “SAYEED” as shown below SYNTAX: SQL> UPDATE USER$ SET… Read more..

Posted in Oracle SQL | Comments Off on Rename a schema in Oracle Database 11gR2

Next Entries »