RE: TDE and mat view

I am running rhel 3.

I just do not know how or if a column in a materialized view can be encrypted via TDE.

I have tried:
alter table test_MV
 modify (fld1 encrypt no salt);

and I get
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view

Thanks
Randy

> -----Original Message-----
> From: GovindanK [mailto:gkatteri_at_fastmail.fm]
> Sent: Thursday, January 04, 2007 2:32 PM
> To: Steiner, Randy; oracle-l_at_freelists.org
> Subject: Re: TDE and mat view
>
> What Platform? Are you encountering any errors.
>
> Take a look at Metalink note 4485775.8 for a related Bug.
>
> HTH
>
> GovindanK
>
> On Wed, 3 Jan 2007 14:52:45 -0500, "Steiner, Randy"
> <Randy.Steiner_at_nyct.com> said:
>
>
> Has anyone figured out a way to use TDE to encrypt a
materialized
> view?
>
>
>
>
>
> Thanks
>
>
>
> Randy
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l