ORA-32794: cannot drop a system-generated sequence

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Dennis Wanke
Posts: 57
Joined: Tue 11 Mar 2014 07:49

ORA-32794: cannot drop a system-generated sequence

Post by Dennis Wanke » Thu 27 Mar 2014 08:00

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-32794: cannot drop a system-generated sequence

Post by Shalex » Thu 27 Mar 2014 14:34

We have reproduced the issue. We will investigate it and notify you about the results as soon as any are available.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-32794: cannot drop a system-generated sequence

Post by Shalex » Wed 09 Apr 2014 14:21

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-32794: cannot drop a system-generated sequence

Post by Shalex » Thu 10 Apr 2014 14:39

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.

Dennis Wanke
Posts: 57
Joined: Tue 11 Mar 2014 07:49

Re: ORA-32794: cannot drop a system-generated sequence

Post by Dennis Wanke » Fri 11 Apr 2014 08:58

I confirm the issue is now fixed.

Post Reply