Re: Reorg active table
From: <srivenu_at_hotmail.com>
Date: Thu, 28 Aug 2008 22:48:04 -0700 (PDT)
Message-ID: <b39536d3-62df-446d-be51-4d41d2f92785@a18g2000pra.googlegroups.com>
Date: Thu, 28 Aug 2008 22:48:04 -0700 (PDT)
Message-ID: <b39536d3-62df-446d-be51-4d41d2f92785@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 Fri Aug 29 2008 - 00:48:04 CDT