schema/spacewalk/oracle/end.sql | 15 +++++++++++++++ schema/spacewalk/oracle/packages/packages.deps | 3 ++- schema/spacewalk/oracle/procs/procs.deps | 1 + 3 files changed, 18 insertions(+), 1 deletion(-)
New commits: commit e928f7af030f63fde68232798ec173e966259ebc Author: Michael Mraka michael.mraka@redhat.com Date: Thu Jul 8 15:12:22 2010 +0200
added dependencies on rhnServerFveCapable
diff --git a/schema/spacewalk/oracle/packages/packages.deps b/schema/spacewalk/oracle/packages/packages.deps index a074659..ba14b77 100644 --- a/schema/spacewalk/oracle/packages/packages.deps +++ b/schema/spacewalk/oracle/packages/packages.deps @@ -29,6 +29,7 @@ rhn_channel.pkb :: rhnChannel rhn_exception.pks rhnServer rhnServerChann rhnChannelPackage rhnChannelErrata rhnSnapshotChannel \ rhnServerUuid rhnChannelPermissions rhnServerEntitlementView \ rhnChannelFamilyServerPhysical rhnSharedChannelView \ + rhnServerFveCapable \ rhn_user.pks rhn_channel.pks :: rhnChannel rhnOrgChannelFamilyPermissions \ rhnServerChannel @@ -45,7 +46,7 @@ rhn_entitlements.pkb :: rhnServerGroupType rhnServerGroup rhnServerGroupMembe rhnUserGroup rhnChannelFamilyMembers rhnServerChannel \ rhnOrgChannelFamilyPermissions \ rhnServerServerGroupArchCompat rhnPrivateChannelFamily \ - rhnServerEntitlementPhysical + rhnServerEntitlementPhysical rhnServerFveCapable rhn_entitlements.pks :: rhnServerGroupType rhn_exception.pkb :: rhnException rhn_exception.pks :: rhnException
commit 1eaab9b570705edb71cc3c53691af8e80ebed6f7 Author: Michael Mraka michael.mraka@redhat.com Date: Thu Jul 8 15:06:01 2010 +0200
lookup_checksum depends on rhnChecksumView
diff --git a/schema/spacewalk/oracle/procs/procs.deps b/schema/spacewalk/oracle/procs/procs.deps index f4e66e4..8d0d248 100644 --- a/schema/spacewalk/oracle/procs/procs.deps +++ b/schema/spacewalk/oracle/procs/procs.deps @@ -67,6 +67,7 @@ is_user_applicant :: rhnUserGroupType web_contact rhnUserGroup \ lookup_arch_type :: data/rhnArchType rhn_exception.pks lookup_channel_arch :: rhn_exception.pks data/rhnException rhnChannelArch \ data/rhnChannelArch +lookup_checksum :: view/rhnChecksumView lookup_client_capability :: rhnClientCapabilityName lookup_config_file_info :: rhnConfigFileInfo lookup_cf_state :: rhnConfigFileState
commit 84db9a9c9ab88aa595c1baf35730e62ebfa11904 Author: Michael Mraka michael.mraka@redhat.com Date: Thu Jul 8 14:50:59 2010 +0200
let schema population fail if there are invalid objects
diff --git a/schema/spacewalk/oracle/end.sql b/schema/spacewalk/oracle/end.sql index 4a4f93e..f9e3bbe 100644 --- a/schema/spacewalk/oracle/end.sql +++ b/schema/spacewalk/oracle/end.sql @@ -14,5 +14,20 @@ --
COMMIT; + +-- check whether all objects are valid +declare + invalid_objects number; +begin + select count(*) + into invalid_objects + from user_objects + where status <> 'VALID'; + if invalid_objects > 0 then + RAISE_APPLICATION_ERROR(-20001, 'SCHEMA POPULATION ENDS WITH INVALD OBJECTS'); + end if; +end; +/ + EXIT
spacewalk-commits@lists.fedorahosted.org