Re: How to change tablespace assigned to tables ?

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Mon, 24 May 1999 10:29:13 -0400
Message-ID: <7ibnpk$p1e$1@ligarius.ultra.net>

Use export/import utilities.
For details see the Oracle Server Utilities manual, Chapter 2: Import, "Reaorganizing Tablespaces" and "Overriding Storage Parameters" .

Good luck,
Eugene.

Roby <roberto.scanavino_at_rsisistemi.it> wrote in message news:01bea5e3$9e322c00$38cab9c2_at_drake...
>
>
> I need to change the tablespace assigned to tables, but dropping the table
> I loose contraints, indexes, and triggers.
>
> I have more the 150 tables then I want to know if there's another way to
do
> it.
>
> Regards,
>
> Roby
>
>
> Roberto.Scanavino_at_rsisistemi.it
Received on Mon May 24 1999 - 09:29:13 CDT