Hi,

Are there any procedure or commands
moving one table into new tablespace from old tablespace , where it
has multiple tables in one tablespace ?


Here's my scenario for moving sample_table into tablespace_new

1. create tablespace_new
2. create table "sample_table_new " in tablespace_new
3. Stop user service
4. load sample_table_new from sampe_table
5. drop all relations on sample_table
view , trigger, foreign key, constraints.
( It so tricky and hard part ,
when it got multiple constrains over multiple tables )

6. Rename sample_table to sample_table_old
Rename sample_table_new to sample_table
7. Create all relations to sample_table
8. Start user service
9. Drop sample_table_old



Env : AIX 5.3/UDB V8.2

Regards
Myoungsoo

Hello Myoungsoo,

This link might be of some use to you. Perhaps you could get your
hands on this (although I formally oppose this idea and suggest you
use this guide to roll your own version):

http://doyoudb2.com/sap-related/50-o...r-sap-db2-dbas

Kind Regards,

Frederik

On Aug 27, 2:07*am, mvsmsh <mvs...@gmail.comwrote: