Reorg active table

Hi,

I need to reorg an active table( lot of insert/update/delete)
I would like to do a move tablespace to shrink the table.
How can I lock all the DML and do the move ?
Thanks in advance
Oracle 9.2.0.6

On 27.08.2008 22:25, astalavista wrote:

> I need to reorg an active table( lot of insert/update/delete)

What makes you think you need a reorganization? Did you consider that
the table might not stay organized for long if there is a lot of
modifications going on? etc.

Cheers

robert

astalavista wrote:
> Hi,
>
> I need to reorg an active table( lot of insert/update/delete)

Why?

Palooka

On Aug 27, 4:25*pm, "astalavista" wrote:
> Hi,
>
> I need to reorg an active table( lot of insert/update/delete)
> I would like to do a move tablespace to shrink the table.
> How can I lock all the DML and do the move ?
> Thanks in advance
> Oracle 9.2.0.6

Read the doc on dbms_redefinition is one way.

OK thanks

Oneway to restrict DML is to seperate the application schema (which
does DML) from the table owner schema.
So during the downtimes (reorg or others like refills etc) you revoke
the privileges from the application schema.
regards
srivenu

OK thanks for the trick ...

a écrit dans le message de news:
b39536d3-62df-446d-be51-4d41d2f92785...oglegroups.com...
> Oneway to restrict DML is to seperate the application schema (which
> does DML) from the table owner schema.
> So during the downtimes (reorg or others like refills etc) you revoke
> the privileges from the application schema.
> regards
> srivenu