Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: moving tables from one tablespace to another

Re: moving tables from one tablespace to another

From: mskoblar <mskoblar_at_hnb.hr>
Date: Tue, 13 Apr 1999 10:56:07 +0200
Message-ID: <MPG.117d251033d9fa50989682@news.tel.hr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US