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
ORA-32794: cannot drop a system-generated sequence
-
- Posts: 57
- Joined: Tue 11 Mar 2014 07:49
Re: ORA-32794: cannot drop a system-generated sequence
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
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
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.
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.
-
- Posts: 57
- Joined: Tue 11 Mar 2014 07:49
Re: ORA-32794: cannot drop a system-generated sequence
I confirm the issue is now fixed.