Re: Online "tablespace" reorg ?

If you were *really* keen, you could manufacture an online facility yourself along the lines:

1. create a trigger to capture every single change to all tables in the tablespace of question in an audit table
2. create new_table as select * from old_table for each table in the tablespace
3. lock both new and old table and then apply the changes in sequence from your trigger

Sort of a home-grown version of dbms_redef for DMT's

Cheers
Connor

On 6/29/05, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
> Another option is CTAS using unrecoverable to prevent logging then
> rename when you are sure it is working. You should use a SQL generate
> SQL script or some other method to pull of all dependencies first.
>
> -----Original Message-----

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l