Re: Online "tablespace" reorg ?
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 29 Jun 2005 10:42:37 +0800
If you were *really* keen, you could manufacture an online facility
yourself along the lines:
a) create a trigger to capture every single change to all tables in
the tablespace of question in an audit table
b) create new_table as select * from old_table for each table in the tablespace
c) 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> 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@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
