Moving tables with constraints

What is the best way to move a table to a different tablespace, including all of its constraints? Without constraints, I could do this:

1. Create tmp table in new t/s as select * from orig table
2. Drop orig table
3. Rename tmp table to orig table

However, step 2 fails if FK constraints reference orig table. I can drop using cascade constraints, but then step 3 won't go back and relink all the FKs in the child tables (obviously).

So, what steps do I follow to move a constrained table to a different tablespace? BTW, what I'm trying to do is move tables out of dictionary managed t/s to locally managed t/s.

Thanks in advance,
Kip Received on Wed Jul 24 2002 - 12:00:06 CDT