# Materialized view creation with Toad wizard

**URL:** <https://forums.toadworld.com/t/materialized-view-creation-with-toad-wizard/39230>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 21, 2017, 5:13am UTC](https://forums.toadworld.com/t/materialized-view-creation-with-toad-wizard/39230 "2017-03-21T05:13:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stececco](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@stececco](https://forums.toadworld.com/u/stececco)\
**Post date:** [March 21, 2017, 5:13am UTC](https://forums.toadworld.com/t/materialized-view-creation-with-toad-wizard/39230/1 "2017-03-21T05:13:56Z")

</div>

Hallo, I’m using Toad Freeware 12.10, and when I create a new materialized view from Schema Browser (Create button) the wizard window appears with the Ok Button disabled.

This button remains disabled even if I write the view name and I compile the Query tab with the correct query parsing done.

So actually I can create a mat.view only with a ddl script. I DON’T have the same problem with creation of a normal view or a table, the Ok button appears enabled with the wizard window.

Creation of a mat.view with a ddl script completes normally without any kind of errors.

I wait for your feedbacks please.

Thanks to all,

Steve

---

<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:** [March 21, 2017, 7:55am UTC](https://forums.toadworld.com/t/materialized-view-creation-with-toad-wizard/39230/2 "2017-03-21T07:55:00Z")

</div>

It’s a freeware limitation. The message when the Create MV window opens should explain that more clearly. I’ll correct it. Thanks.

---

<div class="post-metadata">

**Author:** ![stececco](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@stececco](https://forums.toadworld.com/u/stececco)\
**Post date:** [March 21, 2017, 8:07am UTC](https://forums.toadworld.com/t/materialized-view-creation-with-toad-wizard/39230/3 "2017-03-21T08:07:04Z")

</div>

Right, no message about it appears, only a message about partitioning.

Thank you very much for your reply and your attention,

Steve