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: move lob tables

Re: move lob tables

From: Eric Parker <system.development.team_at_bt.com>
Date: Wed, 20 Jun 2001 22:02:03 +0100
Message-ID: <9gr35n$2rk$1@pheidippides.axion.bt.co.uk>

This is one that I was hoping somebody would be able to answer. I also would like to move a LOB index.

Thanks

eric (eric.parker_at_virgin.net)

"Jim Poe" <jpoe_at_fulcrumit.com> wrote in message news:9gnt46$eq7_at_dispatch.concentric.net...
> I'm trying to move all tables and indexes from one tablespace to another.
> I'm using the following :
>
> set feed off echo off termout off pages 0
> spo Run_Move_Tbl.sql;
>
> select 'alter table '|| owner || '.' ||table_name||' move tablespace
> app_user; ' from
> dba_tables where tablespace_name = 'USER_DATA';
>
> select 'alter index ' || owner || '.' ||index_name||' rebuild tablespace
> app_user; ' from dba_indexes where
> tablespace_name = 'USER_DATA';
>
> /
> spo off;
> @Run_Move_Tbl.sql
>
> This works except for indexes of index_type LOB. How do I move these
> indexes?
>
> Thanks
>
> --
> Jim Poe (jpoe_at_fulcrumit.com)
>
>
Received on Wed Jun 20 2001 - 16:02:03 CDT

Original text of this message

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