Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables with constraints

Re: Moving tables with constraints

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 24 Jul 2002 17:44:09 GMT
Message-ID: <3D3EE725.9A68B88C@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US