Re: Help rewriting query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 Nov 2005 09:10:55 +0100
Message-ID: <403rn19m1outuasd3l0313rl2t3td4hupq@4ax.com>

On 18 Nov 2005 00:00:44 -0800, "News" <Contact_404_at_hotmail.com> wrote:

>it's said :
>
>« You cannot create a materialized view log for a table in the schema
>of the user SYS. »
>
>So Oracle lets you create materialized view log in sys but you cannot
>use it.

Reread the quote in the manual, and explain to yourself you are misinterpreting it. You shouldn't create your own objects in SYS *AT ALL* *EVER* (or you will end up in big trouble). Your conclusion consequently is wrong, and you don't seem to understand the quote. Your problem is you are creating a MV log on a table in the SYS schema, belonging to the dictionary. The restriction is quite reasonable.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Nov 18 2005 - 02:10:55 CST