Page 1 of 1
ORA-32794: cannot drop a system-generated sequence
Posted: Thu 27 Mar 2014 08:00
by Dennis Wanke
Calling ObjectContext.DeleteDatabase() with DeleteDatabaseBehaviour=AllSchemaObjects causes "ORA-32794: cannot drop a system-generated sequence" on Oracle 12c.
For more information see
http://community.oracle.com/message/11134736 and
http://blog.mclaughlinsoftware.com/2014 ... p-a-schema
Re: ORA-32794: cannot drop a system-generated sequence
Posted: Thu 27 Mar 2014 14:34
by Shalex
We have reproduced the issue. We will investigate it and notify you about the results as soon as any are available.
Re: ORA-32794: cannot drop a system-generated sequence
Posted: Wed 09 Apr 2014 14:21
by Shalex
The bug with the Code-First DeleteDatabase() functionality for system-generated sequences in Oracle 12c, when DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects, is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
Re: ORA-32794: cannot drop a system-generated sequence
Posted: Thu 10 Apr 2014 14:39
by Shalex
New build of dotConnect for Oracle 8.3.135 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to
http://forums.devart.com/viewtopic.php?f=1&t=29348.
Re: ORA-32794: cannot drop a system-generated sequence
Posted: Fri 11 Apr 2014 08:58
by Dennis Wanke
I confirm the issue is now fixed.