Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread
Message: 63515
BY: Philip Nelson (scotdb)
DATE: 2009-01-02 11:58
SUBJECT: RE: Moving table to a new database

 

And I also forgot to say that you may need to use the ALTER TABLE command to reset the current identity column value -

db2 "select max(id-col) from table"
db2 "alter table test alter id restart with <max-val-+-1>"

HTH

Phil Nelson
(teamdba@scotdb.com)


Thread View

Thread Author Date
Moving table to a new databaseDavid Adler2009-01-01 23:23
      RE: Moving table to a new databasePraveen Devarao2009-01-02 08:11
            RE: Moving table to a new databasePhilip Nelson2009-01-02 11:52
                  RE: Moving table to a new databasePhilip Nelson2009-01-02 11:58
                        RE: Moving table to a new databasePraveen Devarao2009-01-02 13:06
                        RE: Moving table to a new databaseDavid Adler2009-01-02 14:03
                              RE: Moving table to a new databasePhilip Nelson2009-01-02 14:30

Post a followup to this message