My Oracle Support Banner

Regenerating the OWB "" File by Running the Script "reset_repository.sql" Fails With ORA-29532 (Doc ID 578740.1)

Last updated on JULY 12, 2018

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.


Regeneration of the file by running the script $OWB_HOME/owb/rtp/sql/reset_repository.sql fails with the following:

SQL> @reset_repository.sql <password>
Enter value for repos_password: <password>
old   2:   wb_rti_util.reset('&REPOS_PASSWORD.');
new   2:   wb_rti_util.reset('<password>');
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_RANDOM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "<REPOSITORY_OWNER>.WB_RTI_UTIL", line 29
ORA-06512: at "<REPOSITORY_OWNER>.WB_RTI_UTIL", line 93
ORA-06512: at line 2




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.