Shangwu wrote:
> Daniel,
>
> Thank you for the quick response. Pardon me for reposting on multiple
> groups. Because I am new in this area and not sure which group is proper for
> the question.
> What we want to do is to create a tool that can create table partitions and
> take some partition off line if the data in the partition is not accessed
> recently. This activity could cause the existing applications broken if we
> don't update their queries. So if we can filter the SQL parser of Oracle,
> all existing queries can be modified to exclude the offline partition.
> It seems that DBMS_RLS is not what we can utilize and DBMS_ADVANCED_REWRITE
> is only supported in 10g. Our target Oracle servers include 9.x.
>
> Regards,
>
> Shangwu
>
>
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1126126462.164787_at_yasure...
>
>>Shangwu wrote:
>>
>>>Hello,
>>>
>>>I want to create a program in PL/SQL or C/C++ to interpret and modify all
>>>SQL statements coming to an Oracle server. Is it possible to hook such
>>>program to the SQL parser of Oracle?
>>>Any comment is appreciated.
>>>
>>>Shangwu
DBMS_RLS can be made to do it with a small amount of creativity. But it
seems pointless to take tablespaces off-line. Why not ust make them
read-only and forget them.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Sep 07 2005 - 17:31:00 CDT
