rem
rem This script can be used to reset the registration details for
rem an OWB Repository. Note it also stores the given password as the password
rem for the OWB Repository (see also 'set_repository_password.sql')
rem
rem USAGE
rem Logon as the OWB Repository Owner (OWBSYS) and provide its password as a parameter
rem
rem    @<OWB-HOME>/owb/rtp/sql/reset_repository.sql <password>
rem
rem (This value becomes the new value registered for the Repository.)
rem
rem Note that after the registration details have been reset, you will
rem have to register the passwords for all locations previously registered.

set serveroutput on;

set echo off
set verify off
set role OWB_USER;

define REPOS_PASSWORD = &1.

declare
begin

  owbsys.wb_rt_script_util.reset_repository('&REPOS_PASSWORD.');

end;
/