How to change constraint names

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
mfriend
Posts: 9
Joined: Thu 30 Oct 2014 15:26

How to change constraint names

Post by mfriend » Wed 12 Nov 2014 18:56

Hi Folks:

I like to give 'custom' names to all of my constraints.
Oracle gives default constraint names to check constraints that look like the following:

Image

If I right click on the constraint name and choose "Edit Constraint" I get the following:

Image

The only problem is the name (like SYS_C0014960) is read only it seems. I am logged in as a user that has the right permission level. Am I missing something on how to rename these?

Matthew

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: How to change constraint names

Post by alexa » Thu 13 Nov 2014 15:34

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

mfriend
Posts: 9
Joined: Thu 30 Oct 2014 15:26

Re: How to change constraint names

Post by mfriend » Thu 13 Nov 2014 15:49

That's awesome, thanks.

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: How to change constraint names

Post by alexa » Fri 30 Jan 2015 14:17

We would like to let you know that we have released a new version 3.7 of dbForge Studio for Oracle where the issue you reported is fixed http://www.devart.com/dbforge/oracle/st ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.

babamithan
Posts: 1
Joined: Thu 12 Feb 2015 07:37

Re: How to change constraint names

Post by babamithan » Thu 12 Feb 2015 07:45

Hello, I recently migrated my application to the 8.4.171 version and I get the following error when running a Linq query "ORA-12704: character set mismatch".

If I check the history of updates, it indicates that this problem has been fixed with Version 7.9.333! ...

Another subsidiary question: Where did the Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls property?

Thank you for your answer





____________________
http://www.win-on-slots.com/
Last edited by babamithan on Sat 16 Jan 2016 09:56, edited 2 times in total.

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

Re: How to change constraint names

Post by Shalex » Fri 13 Feb 2015 15:42

babamithan wrote:I recently migrated my application to the 8.4.171 version and I get the following error when running a Linq query "ORA-12704: character set mismatch"
Please refer to http://forums.devart.com/viewtopic.php?t=31063.

JIC: you can find out the generated SQL with dbMonitor (download link, documentation).

If this doesn't help, send us a small complete test project with the corresponding DDL/DML script of database objects to reproduce the issue in our environment.

Post Reply