Hi all,
How can I change the dbspace assignment of table without RE-CREATE it ?
.... consider that this table has many Referencing tables ....
Thanks.
Nicola.

You will pretty much need to recreate it one way or another.

Probably the cleanest approach is to create your dbspace
and then manually rebuild the database, stopping to alter
the reload.sql file to add the 'ON DBSPACE' clause to
your create table statement. That approach will recover
space from you old table and that will shrink your SYSTEM
dbspace size while automatically moving the data to the
new dbspace.

Short of that you will need to deal with all those referencing
tables somehow. One way may be to do this in steps,
creating a new table (with a new table name), add references
to the new table, move the data across, drop the old references
to the old table, and then drop the old table. (one step at a
time, one reference at a time) Of course you will need to
also address the application requirements (which may not
follow such a table name change) so you may find you
need to rename the target table as well (alter table rename stmt).



"Nicola Cisternino" <ncister (AT) cointa (DOT) it> wrote