Re: Help a newbe??

"Peter Häusler" <luciver_at_teleweb.at> wrote in message news:p6sy5.20802$cN5.1874621_at_news.chello.at...
> Is it possible to move a table from tablespace to a another tablespace???
>
>
For all newbies: as a minimum include your platform and your Oracle version. Most questions require a version specific example, this is yet another example
in 7.3 and 8.0
- use exp and imp
or
- create table <new_table> tablespace <new_tablespace> as select * from old_table
in 8i
use alter table move

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Sep 21 2000 - 00:00:00 CEST