Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables with constraints
Kip Gray wrote:
> 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
In what version of Oracle?
Crystal ball is out for repairs this century.
Daniel Morgan Received on Wed Jul 24 2002 - 12:44:09 CDT