Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: replication, Materialized views, and transparent data encryption

Re: replication, Materialized views, and transparent data encryption

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 25 Apr 2006 12:45:28 +0200
Message-ID: <e2kuhs$3v2$2@news3.zwoll1.ov.home.nl>


Maxim Demenko wrote:

>>
>> The ORA-01732 could be thrown because you did not create
>> an updateable MV.

>
> Yes, i know (i was not sure - "alter table modify (column encrypt)"
> equals to data modification), but i implied , OP was asking about read
> only MV, maybe i am wrong.

Would that be the MV table, or the originating one?

It's interesting to see you can build MV's - I would have said you could not, reading the manual, from tables with encryption.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Apr 25 2006 - 05:45:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US