Re: Reorg active table
From: astalavista <nobody_at_nowhere.com>
Date: Sat, 30 Aug 2008 08:13:57 +0200
Message-ID: <48b8e51c$0$4924$426a74cc@news.free.fr>
Date: Sat, 30 Aug 2008 08:13:57 +0200
Message-ID: <48b8e51c$0$4924$426a74cc@news.free.fr>
OK thanks for the trick ...
<srivenu_at_hotmail.com> a écrit dans le message de news:
b39536d3-62df-446d-be51-4d41d2f92785_at_a18g2000pra.googlegroups.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
Received on Sat Aug 30 2008 - 01:13:57 CDT