Re: Move table from one tbs to another

You can try the following:

create table test tablespace some_tablespace as select * from scott.emp

SC <s_c_99_at_hotmail.com> schrieb in im Newsbeitrag: 38A19CEF.E500B3CC_at_hotmail.com...
> can anyone please advice me how to move
> a table from one tablespace (say system)
> to another?
> I thought of using export and import but
> in that case, I think, import will put
> the table back to the same original tablespace.
>
> I am using Oracle 7.3.3, VMS ALpha.
>
> Thanks.
>
> SC
> S_C_99_at_hotmail.com
Received on Fri Feb 11 2000 - 15:14:11 CST