Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\upg\upg10201to10202.sql

-- In-place Design Repository Upgrade to OWB 10.2.0.2.0 ...

ACCEPT V_HOST PROMPT 'Host Name: '
ACCEPT V_PORT PROMPT 'Port Number: '
ACCEPT V_SERVICENAME PROMPT 'Service Name: '
ACCEPT V_USER_NAME PROMPT 'Existing OWB Repository Owner Username: '
ACCEPT V_USER_PASSWORD PROMPT 'Existing OWB Repository Owner Password: ' HIDE
ACCEPT V_SYS_USER_NAME PROMPT 'SYS User Name: '
ACCEPT V_SYS_USER_PASSWORD PROMPT 'SYS User Password: '  HIDE
PROMPT 
PROMPT Review above entries and press
ACCEPT V_DUMMY PROMPT ' <ENTER> to continue or Ctrl-C to cancel'

PROMPT Start Repository upgrade from OWB 10.2.0.1 to OWB 10.2.0.2.0 ...

PROMPT Start updating User Grants for OWB 10.2.0.2.0 Repository...

PROMPT Connect to SYS user ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_SYS_USER_NAME/&V_SYS_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME ))) AS SYSDBA
WHENEVER SQLERROR CONTINUE

@load_java.sql V_USER_NAME V_USER_PASSWORD

SPOOL LOG.TXT

@UpdateReposUsers.pks
@UpdateReposUsers.pkb

SET ESCAPE %

PROMPT bug 5330707
grant  SELECT, INSERT, DELETE, UPDATE on &V_USER_NAME%.DROP_MISC_OBJECTS to OWB_&V_USER_NAME;

PROMPT bug 5568194
grant EXECUTE on &V_USER_NAME%.wb_rti_target_schema_privs to OWB_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_target_schema_objs to OWB_&V_USER_NAME;

PROMPT bug 5565683
grant SELECT on &V_USER_NAME%.all_iv_COLLECTION_REFERENCES to OWBR_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.ALL_IV_PLS_RECORDS  to OWBR_&V_USER_NAME;

grant select on &V_USER_NAME%.ALL_IV_EXPERTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_VARIABLES to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_PARAMETERS to  OWBR_&V_USER_NAME;

grant select on &V_USER_NAME%.ALL_IV_EXPERT_TRANSITIONS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_NESTED_EXPERTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_TASKS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.OWB_XML_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.OWB_SQL_COLLECTIONS   to OWBR_&V_USER_NAME;

grant select on &V_USER_NAME%.ALL_IV_UDO_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_FCOS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_FOLDERS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_SCOS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_ASSOCIATIONS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_PLUG_MAP_COMPONENTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_PLUG_MAP_PARAMETERS to  OWBR_&V_USER_NAME;

-- Update all repository users version numbers
exec UpdateReposUsers.UpdReposUsers(%'&V_USER_NAME%', '10.2.0.2.0');
commit;

SET ESCAPE OFF;

PROMPT Connect to Design repository user ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_USER_NAME/&V_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME )))
WHENEVER SQLERROR CONTINUE

PROMPT bug 5442191 - Step 1
@bug5442191_step1.sql

PROMPT bug 5390587
PROMPT bug 5417117 / 5352671
@../SnapshotTrigger.pks
@../SnapshotTrigger.plb

/
PROMPT bug 5518634
@../../rtasst/wb_rt_profile.sql
@../../rtasst/roles_object_rights.sql
@../../rtasst/wb_rt_profile_service.pls
@../../rtasst/wb_rt_profile_service.plb
@../../rtasst/wb_rt_target_schema_objs.pls
@../../rtasst/wb_rt_target_schema_objs.plb 
@../../rtasst/wb_rti_target_schema_privs.pls
@../../rtasst/wb_rti_target_schema_privs.plb
/

PROMPT bug 5517112 
@../../rtasst/wb_rt_platform_audit_views.sql
/

PROMPT bug 5128822 / 5123703
@../../browserasst/views/public_utils.sql 
@../../browserasst/views/public_utils_body.plb 
@../../browserasst/views/public_views.sql 
/
PROMPT bug 5390587
PROMPT bug 5417117 / 5352671
@../SnapshotTrigger.pks
@../SnapshotTrigger.plb
@../SnapshotCreateRestore.pks
@../SnapshotGenerated.pks
@../Snapshot.pks
@../SnapshotMXS.pks
@../SnapshotImport.pks
@../SnapshotError.pks
@../SnapshotTrigger.plb
@../SnapshotCreateRestore.plb
@../SnapshotGenerated.plb
@../Snapshot.plb
@../SnapshotMXS.plb
@../SnapshotImport.plb
@../SnapshotError.plb
/
commit;

PROMPT Invoke upversion_10202.sql ...
@upversion_10202.sql;
/

PROMPT Recompile packages... 1st pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));
PROMPT Recompile packages... 2nd pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));
PROMPT Recompile packages... 3rd pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));

PROMPT End of the upgrade.
SPOOL OFF
exit

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de