Re: how to change table's tablespace?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Oct 2000 15:09:20 +0200
Message-ID: <972134920.3696.2.pluto.d4ee154e@news.demon.nl>

it does work if you

alter user <target_user> default tablespace user_data;
alter user <target_user> quota unlimited on user_data quota 0 on system
quota 0 on <all other tablespaces>;

revoke unlimited tablespace from <target_user>;

imp ..... indexes=n
imp ... indexfile=<any filename>
edit the <any filename> changing the tablespace and run <any filename> in sqlplus.

Hopefully this is sufficient info for you.

Regards,

Sybrand Bakker, Oracle DBA

<wy_at_fudan.edu> wrote in message news:8ss1p5$1dc$1_at_nnrp1.deja.com...
> someone creates a user without specifying the user tablespace.
> and have created 100 tables and indexes on the system tablespace.
>
> I want to change these tablespaces(system) to user_data.
> How can I do?
>
> I tried exp/imp, but not work!
>
>
> Thanks.
>
> wy.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Oct 21 2000 - 08:09:20 CDT