ORA-32794: cannot drop a system-generated sequence

ORA-32794: cannot drop a system-generated sequence

Postby 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/01/17/cleaning-up-a-schema
Dennis Wanke
 
Posts: 57
Joined: Tue 11 Mar 2014 07:49

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

Postby 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
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

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

Postby 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
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

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

Postby 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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

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

Postby Dennis Wanke » Fri 11 Apr 2014 08:58

I confirm the issue is now fixed.
Dennis Wanke
 
Posts: 57
Joined: Tue 11 Mar 2014 07:49


Return to dotConnect for Oracle