How to change constraint names

[mfriend]

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:



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



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]

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

[mfriend]

That's awesome, thanks.

[alexa]

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]

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/

[Shalex]

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.