Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unique constraint delete issue

anand_gpMay 20 2018 — edited May 23 2018

Hi,

I created an unique constrain on a table.  And then removed it to include one more column.  Then again I try to create it (with same name) -

ALTER TABLE EMB_PRINT_OUTWARD_DETAIL 
ADD CONSTRAINT EP_OUT_DET_UNIQ_FID_PART 
UNIQUE (FAB_INWARD_DET_SEQ_NO, PURPOSE, PART_ID);

I get error as -

ORA-02261: such unique or primary key already exists in the table

I thought it still exists and  I try to drop it again - 

ALTER TABLE EMB_PRINT_OUTWARD_DETAIL drop CONSTRAINT EP_OUT_DET_UNIQ_FID_PART;

but I get the error as -

ORA-02443: Cannot drop constraint - nonexistent constraint

If I try to search that with below query, I get no data found -

select * from USER_constraints where constraint_name = 'EP_OUT_DET_UNIQ_FID_PART';

If I try that from SYS user account, still no such constraint present -

select * from dba_constraints where constraint_name = 'EP_OUT_DET_UNIQ_FID_PART';

And if I try to perform an insert I get error -

ORA-00001: unique constraint (PAN_GAR.EP_OUT_DET_UNIQ_FID_PART) violated

That mean, the constraint exists on the database !  But it is not visible to delete or even recreate !  I use Oracle 11g (11.2.0.x)

Can you please let me know what's going wrong here.  Thanks,

-Anand
This post has been answered by anand_gp on May 20 2018
Jump to Answer

Comments

843810
Have browsed through the forum and it seems that the
JCE provider bundled with JCE and JDK1.4+ do nothing
on RSA. Can I make this conclusion?
Yes, but: A standard installation of Java comes with 5 providers. SunJCE is only one of these providers. Two other providers, SunJSSE and SunRsaSign do provide RSA for digital signature purposes.
843810
But it seems the SunJCE doesn't provide the RSA (and AES, who knows what else is missing) encryption and decryption functions. Can anyone list what is missing from the SunJCE? Also, from the forum, many have pointed to this bounty castle provider. Can any of you guys who are familiar with this provider give us the procedure of installation? Thanks.
843810
But it seems the SunJCE doesn't provide the RSA (and
AES, who knows what else is missing) encryption and
decryption functions. Can anyone list what is missing
from the SunJCE? Also, from the forum, many have
pointed to this bounty castle provider. Can any of
you guys who are familiar with this provider give us
the procedure of installation? Thanks.
I wouldn't use the term 'missing' here. Sun provides some basic cryptographic functions and that all. If you want more, get another provider. Sun will never be able to provide every possible algorithm. That's why they have implemented the external provider option. So no, I cannot list what is missing.

I can tell you that other providers, for instance BouncyCastle offer much more cryptographic functions. Installation is very easy. Just download the .jar and put it in your <java>\jre\lib\ext directory. After that you can use it in you programs with the following code: 
Provider prov = new org.bouncycastle.jce.provider.BouncyCastleProvider();
Security.addProvider(prov);
You can also install it so that you don't have use this code in every program that uses the provider. How this is accomplished, can be found in the install manual from BouncyCastle.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 20 2018
Added on May 20 2018
4 comments
2,288 views