Re: How to change object's tablespace ?

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sun, 23 Sep 2001 20:43:34 GMT
Message-ID: <3bae468a.4150678@news.mobilixnet.dk>

On Sun, 23 Sep 2001 16:05:50 +0200, "Djuro D" <Djuro.Dretvic_at_Infodom.hr> wrote:

>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
>
>
>
>

Prevention :
1) Change the developers' default tablespace from system to users. 2) Reduce their tablespace quota on system tablespace to 0.

Cure(s) :

1) Alter index rebuild tablespace...
2) export/import
3) create table destination_table tablespace users as (select  * from

origin_table)
4) alter table move... (8i or higher).

---

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sun Sep 23 2001 - 15:43:34 CDT