Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: move lob tables
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