Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nested tables recursive SQL

653633Aug 5 2008 — edited Aug 5 2008

Hello, I am trying to figure out why I get the following error message

ORA-00604: error occurred at recursive SQL level 1
ORA-22914: DROP of nested tables not supported

I am using the TOAD tool to create tables using CTAS and I have managed to create several tables using the same SQL that is failing now with the only difference being a portion of the WHERE clause.

Any help will be very much appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2008

Added on Aug 5 2008

#general-database-discussions

1 comment

885 views