Search This Blog

Saturday, 9 July 2011

Oracle Application APEX admin user password reset by script

Introduction: If you dont know the password for admin user of Oracle Application APEX, and if version of APEX is 3 or higer then the password of admin can be reset by a script. CookBook: There is script in the directory of apex softwae and the script name is apxchpwd.sql, this can be run with sys user on sqlplus and it will ask the new password for admin, just type the new password and use it.

No comments:

Create DB link in another db user

 To test / create the db link in another db user schema following procedure can be used. create or replace procedure tst_user.dblink   is ...