The fix is to update the database with statements similar to the following.
Note that you must quit the SQL editor to see the changes.
> update packagerev_usage
set packagerev_dbid =
(select master_dbid from packagerevs_1 where package_dbid =
(select master_dbid from packages_1 where name = 'PACKAGE') and rev_string = 'NEWREV')
where package_dbid =
(select master_dbid from packages_1 where name = 'PACKAGE') and packagerev_dbid =
(select master_dbid from packagerevs_1 where package_dbid =
(select master_dbid from packages_1 where name = 'PACKAGE') and rev_string = 'OLDREV') and
schema_name = 'SCHEMANAME';
Back to the INDEX.
Return to the home page .
This page last modified: 12/15/2008