SqlDbx Forum

timeco

Member

MATERIALIZED VIEW wrong scripting

Hi,

when using "Create script " on a materialized view in Oracle, Sqldbx creates an invalid command for dropping this view.
The correct syntax should be: DROP MATERIALIZED VIEW custom_name   instead of current: DROP VIEW custom_name -> this causes an error...   The Create statement is correct though.

I'm using Sqldbx 3.51.

Goran

sqldbxhelp

Administrator

Re: MATERIALIZED VIEW wrong scripting

Thank you for reporting this bug. This issue will be addressed in a next release.