Welcome to All Things Warehouse Builder

Unregistering a Location

Jean-Pierre Dijcks
Master Product Manager

Just noticed this script, which I think many people might not be aware of. Ok it is not something you would need every day, but in some cases you may find yourself in need of it...

In <OWB_HOME>/owb102/owb/misc you find 3 scripts:

  • unregister_location.sql
  • wb_env_util.plb
  • wb_env_util.pks
The only one you care about is the SQL one... Now use this only (like the script says) when you cannot get to the control center anymore. Say the database got deleted (runtime that is), but your location in the client still says it is registered. Since you cannot go to the control center an unregister, you need to do something. That is where unregister_location.sql comes in...

Before running it do read the script, it nicely tells you which user to use it in (Repository Owner).

Oh and for those of you new to 10.2, you should not declare this the default to unregistering a location... 10.2 has this capability in the Control Center Manager and you do not have to go to the browser... So it is already quite a bit simpler. Remember just use this one when you are really stuck.

Join the discussion

Comments ( 3 )
  • guest Tuesday, June 14, 2011

    This is not working. I got the message location not avaialable.

  • David Thursday, June 16, 2011

    Are you unregistering when you are connected to the database with a user who has the location registered? Can you include what you did and the exact error.



  • guest Thursday, June 16, 2011


    I really appreciate your comment and time.

    I agree with you 100%. But present situation is DBA refreshed the development database from production and dropped all DB links.

    SQL> @C:\OWB10g\owb\misc\unregister_location.sql;



    This script should be used ONLY when a location cannot be unregistered by using

    OWB UI or Scripting. This can happen when the Control Center/Runtime Repository

    where this location was registered is crashed, or deleted, or just cannot be

    reached any more.


    Enter Location Name (ctrl/c to cancel): L_XXX_XXXXXXX

    Location L_XXX_XXXXXXX does not exist

    PL/SQL procedure successfully completed.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.