Home » SQL & PL/SQL » SQL & PL/SQL » Creating CLustered Primary Key in Oracle (Oracle 10gR2)
Creating CLustered Primary Key in Oracle [message #345123] Tue, 02 September 2008 06:39 Go to next message
coolfrenz
Messages: 1
Registered: September 2008
Junior Member
Hi,
In SQL server while declaring the primary key clustered/non clustered can be specified. How can the same be done in oracle. I know how to make clustered indexes but making primary key clustered is still a big question.

Thanks,
Piyush

[Updated on: Tue, 02 September 2008 06:40]

Report message to a moderator

Re: Creating CLustered Primary Key in Oracle [message #345127 is a reply to message #345123] Tue, 02 September 2008 06:44 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Simply specify primary key.

Oracle have clustered tables having clustered key.

Regards,
Rajat

Re: Creating CLustered Primary Key in Oracle [message #345131 is a reply to message #345123] Tue, 02 September 2008 06:48 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Different RDBMS, different objects, different meanings, different usages.

Regards
Michel
Previous Topic: SQL Query
Next Topic: DB2 to Oracle SQL return codes
Goto Forum:
  


Current Time: Sat Dec 10 18:19:49 CST 2016

Total time taken to generate the page: 0.04638 seconds