[Spacewalk-list] Spacewalk schema upgrade 0.3 to 0.4

[Scott Page]

Hi all

     I was following the upgrade instructions on the wiki and got the 
following in my log.


'SPACEWALK-SCHEMA-0.3-TO-SPACEWALK-SCHEMA-0.4/156-RHNPACKAGE-COMPAT-NUMBER.SQ
-----------------------------------------------------------------------------
spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql

SQL> --
SQL> -- Copyright (c) 2008 Red Hat, Inc.
SQL> --
SQL> -- This software is licensed to you under the GNU General Public 
License,
SQL> -- version 2 (GPLv2). There is NO WARRANTY for this software, 
express or
SQL> -- implied, including the implied warranties of MERCHANTABILITY or 
FITNESS
SQL> -- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
SQL> -- along with this software; if not, see
SQL> -- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
SQL> --
SQL> -- Red Hat trademarks are not licensed under GPLv2. No permission is
SQL> -- granted to use or replicate Red Hat trademarks that are incorporated
SQL> -- in this software or its documentation.
SQL> --
SQL> --
SQL> -- $Id$
SQL> --
SQL>
SQL> alter TABLE rhnPackage MODIFY (compat number(1));
alter TABLE rhnPackage MODIFY (compat number(1))
                                *
ERROR at line 1:
ORA-01440: column to be modified must be empty to decrease precision or 
scale