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 a tablespace

Re: Moving tables from a tablespace

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 3 Nov 1999 08:00:53 -0500
Message-ID: <7vpf1s$loq$1@autumn.news.rcn.net>


Hi Raju,

    If you are using 8i you can move the tables. If not and you aren't ready to upgrade to 8i things are more comoplex. Basically what you want to do is export the tables you want to move, drop the tables, create the empty tables/indexes in the new tablespaces, and do an import with the ignore=y option. (I just moved 213 tables this way so I know it works.)

hth
jerry gitomer

raju_pillai_at_yahoo.com wrote in message
<7voea8$4og$1_at_nnrp1.deja.com>...
>We have a bunch of tables in a single tablespaces and I would
like to
>move them to different tablespaces. I have already created the
necessary
>tablespaces for those tables including tablespaces for their
indexes.
>Now I am ready to move the tables and the data. How can I do
this in the
>most efficient way. I also need the indexes and contraints for
those.
>Can anybody suggest me the best way to accomplish this.
>
>Any input is greatly appreciated.
>Thanks
>
>Raju
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 03 1999 - 07:00:53 CST

Original text of this message

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