Re: how to change table's tablespace?

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Sat, 21 Oct 2000 23:13:53 +0900
Message-ID: <qyhI5.3$iM.381@news.hananet.net>

In Oracle 8i server you can do it like below.

alter table <tablename> tablespace users;

if all your table is on the system tablespace then do like this.

sqlplus scott/tiger
SQL> spool test
SQL> select 'alter table '||table_name||' tablespace users;'

2> from user_tables;
SQL> spool off
SQL> @test.lst

Good luck to you!!!

<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 - 09:13:53 CDT