Toad for Oracle 14.1.10.751 Bug When Adding Constraint to View

Toad for Oracle - Beta
1

I was attempting to add a PK to a View to see if it would make some Visual Studio developers lives easier and the SQL that Toad generates for this is incorrect and will not run. Here is a screen shot of the Create Constraint Window:

image

You can see this is a View (circled in Orange in the above image). When you click "Show SQL" you see the following:

image

It should read ALTER VIEW... not ALTER TABLE...

I am connecting to an Oracle 19 DB with Oracle Client 18.3.0.0 . Let me know if you need any additional info.

2

Thanks. I see that and will fix soon.

As a workaround, double-click the view from the schema browser to open the "Alter View" window and add the constraint there.

3

I just snagged the the SQL and changed TABLE to VIEW and executed.

1 Like
4

Fixed in the current beta, which you can get here. Toad for Oracle 14.1 Beta

A change log is in the comments section of that link.