Re: How to change object's tablespace ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 23 Sep 2001 16:26:15 +0200
Message-ID: <tqrs9d8pi05v3d@news.demon.nl>

"Djuro D" <Djuro.Dretvic_at_Infodom.hr> wrote in message news:9okpjf$rqa$1_at_sunce.iskon.hr...
> Hi,
>
> What is the best way to move object (tables, indexes etc. ) from one
> tablespace to another tablespace ?
>
> Here is my problem. Our developers put their object's in system
tablespace.
> I have to move them into the useres tablespace.
> What is the easiest solution ?
>
> Thanks in advance.
>
> Regards, Djuro
>
>
>

Tne answer is partly version specific. Please *always always* include those 3 digits and two dots. No one in this group has a crystall ball and/or will assume you are running with the latest version. From 7.3 onwards indices can be rebuild using alter index rebuild In 8i a table can be moved with alter table move Before 8i this would require either a CTAS (Create table as select) and some fiddling, or export / import.

Regards,

Sybrand Bakker, Senior Oracle DBA

>
Received on Sun Sep 23 2001 - 09:26:15 CDT