Skip to Main Content
Forums

SQL Developer

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.

Primary Key in SQL developer and SQL Script for a Table

872483Dec 8 2014 — edited Dec 8 2014

Hi,

Primary key is not shown anywhere in Column Tab in SQL Developer (Version 4.0.1.14)

Like, I checked this thread,

https://community.oracle.com/thread/1098041?q=Primary%20Key%20in%20SQL%20developer

So it says, its not shown. But since the thread was like 4 years old and for different version, just wanted to cross check if this feature is added in recent times.

One more thing, I tried to take the DDL script for the table, it no where shows as Primary Key, it just shows as UNIQUE INDEX.

Is unique index same as primary key??

If same, Why to create unique index instead of primary key??

Why oracle EBS standard tables use unique index instead of primary key?? (Sorry if it is irrelevant to this link)

Thanks.

Comments

Dude!
Answer

You need to contact Oracle sales and can review licensing information available on the web. No one here can or will give you any official licensing advice.

Marked as Answer by user1441180 · Sep 27 2020
BPeaslandDBA

I would also be wary of the Nutanix claims about running Oracle on their hyperconverged solution. I had a Nutanix salesman repeatedly tell me things I know are false as far as Oracle licensing is concerned. The salesman did also mention some things which could be true but I thought was in a grey area. In the end, my company decided not to buy their solution, but not for Oracle licensing reasons. So I never looked into licensing Oracle on Nutanix in any more depth after that.

I also remember the early days of VMWare and that company's literature on Oracle licensing for their products. VMWare's claims on how to reduce licensing costs using their products were later debunked by Oracle Corp. My point of this is just because the vendor makes claims about how Oracle licensing will work on their product doesn't mean its fact. Oracle Corp is the only one that can determine licensing specifics, not some third-party vendor. And Oracle is already on record that saying any form of soft partitioning is not used as a means to limit the number of licenses needed.

You're doing the right thing about questioning Oracle licensing on Nutanix. I don't trust Nutanix nor VMWare to be the definitive answer on licensing for some product they have no control over. Trust the products vendor, Oracle. After all, Oracle is the one that will audit you. I'm not saying licensing on Nutanix is a bad nor a good thing. I truthfully do not know. But before I would commit to running Oracle on Nutanix, I'd get the answers from Oracle and no one else..and I'd get it in writing.

If your reseller is unhelpful, then might I suggest its time to find another reseller? There are lots out there. You can also contact Oracle Sales directly and not go through a reseller.

I also found this link which may be of interest to you: http://www.redwoodcompliance.com/oracle-licensing-in-nutanix/


Cheers,

Brian

user1441180

Hi,

Thanks for both responses. We are not looking for official advice, we would just like to find any relevant documentation.

Will contact Oracle sales.

Thanks,

William

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2015
Added on Dec 8 2014
#sql-developer, #sqldeveloper
5 comments
1,701 views