# Error creating materialized view

**URL:** <https://forums.toadworld.com/t/error-creating-materialized-view/55667>\
**Category:** Toad for Oracle - Beta\
**Created:** [July 21, 2022, 7:05pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667 "2022-07-21T19:05:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjsystemss](https://avatars.discourse-cdn.com/v4/letter/m/ce73a5/32.png) [@mjsystemss](https://forums.toadworld.com/u/mjsystemss)\
**Post date:** [July 21, 2022, 7:05pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667/1 "2022-07-21T19:05:23Z")

</div>

How can I create materialized view log?.  
I get the error below. For easier understanding can you create a materialized view using statement  
SELECT \*  
FROM Dual

with WIZARD. This will help me better in GIF.

 ![image](https://global.discourse-cdn.com/quest/original/2X/c/c5ecf27bac146b399a9876cc2d0bc15ad11fbc7d.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 21, 2022, 7:11pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667/2 "2022-07-21T19:11:30Z")

</div>

Hi Matthew.

First, you should create a different user to test with, then log out of SYS and log in as your newly created user. Doing anything in the SYS schema is dangerous and it can wreck your database.

Second, that isn't an error, it's just telling you that you need to create a MV Log on this table before you can create a MV. ANd if you click 'Yes', it will take you to the Create MV Log window for the SYS.ARGUMENT$ table. **But you should never do that to SYS's objects**.

Cancel out of that window and do this

1. Open the editor;
2. paste this in:  
Create user matthew identified by matthew;  
grant dba to matthew;
3. Hit F5 to run that
4. log out, then log back in as matthew/matthew
5. Now create whatever objects you want.

-John

---

<div class="post-metadata">

**Author:** ![mjsystemss](https://avatars.discourse-cdn.com/v4/letter/m/ce73a5/32.png) [@mjsystemss](https://forums.toadworld.com/u/mjsystemss)\
**Post date:** [July 21, 2022, 7:14pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667/3 "2022-07-21T19:14:36Z")

</div>

Thanks I will try that

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 21, 2022, 7:17pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667/4 "2022-07-21T19:17:48Z")

</div>

You're welcome. After you are logged in as Matthew, an easy way to make a table to test with is to run this in the editor:

create table test\_table as select \* from dba\_tables;

That will give you a table with about 3000 rows.

---

<div class="post-metadata">

**Author:** ![mjsystemss](https://avatars.discourse-cdn.com/v4/letter/m/ce73a5/32.png) [@mjsystemss](https://forums.toadworld.com/u/mjsystemss)\
**Post date:** [July 21, 2022, 7:19pm UTC](https://forums.toadworld.com/t/error-creating-materialized-view/55667/5 "2022-07-21T19:19:12Z")

</div>

thank you john. I am able to create connection to the database. let me try the steps you have provided.