Re: replication, Materialized views, and transparent data encryption

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Mon, 24 Apr 2006 17:10:20 +0200
Message-ID: <444ceb66$0$11073$9b4e6d93@newsread4.arcor-online.net>

EdStevens schrieb:
> Platform: Oracle 10.2 EE on Win2003 server
>

> It says "Materialized views cannot be based on tables that contain any
> columns encrypted using transparent data encryption." Does this mean
> that the MV table can't have encryption on it, or does it mean that the
> master table from which it is pulling cannot have encryption?
>
> Thanks.
>

I've done some quick tests, it seems, the former is meant. I could create materialized view as select * from table_with_encrypted_columns, data in the materialized view however don't get encrypted. Wenn i tried to encrypt column of materialized view container table with "ALTER TABLE MV_TABLE MODIFY COLUMN(MY_COLUMN ENCRYPT)", i got ORA-01732: data manipulation operation not legal on this view.

Best regards

Maxim Received on Mon Apr 24 2006 - 10:10:20 CDT