Daniel Morgan wrote:
> 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
>
Peering into my crystal ball (which just came back from the repair
shop), Oracle8i Rel 2 (aka 8.1.7).
Kip
Received on Wed Jul 24 2002 - 12:49:28 CDT