Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving tables from one tablespace to another
In article <7eu3hc$nt2$1_at_nnrp1.dejanews.com>, amohamme_at_my-dejanews.com
says...
> I'll have to move move 2 tables from the existing tablespace into 2
> corresponding new tablespaces.
> Which will be the best way to get this done.
>
> Thanks,
>
> Abeeda
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
Export the tables. Drop them. Create new tables in desired tablespaces, import tables with IGNORE option. Received on Tue Apr 13 1999 - 03:56:07 CDT