From oracle-l-bounce@freelists.org Fri Oct 14 09:24:39 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9EEOQgg021119 for ; Fri, 14 Oct 2005 09:24:26 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9EEOKvX021089 for ; Fri, 14 Oct 2005 09:24:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3896B1FECE1; Fri, 14 Oct 2005 09:24:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16660-01; Fri, 14 Oct 2005 09:24:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 83AD21FEB8F; Fri, 14 Oct 2005 09:24:06 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=kAMO2aEv0ydO4Umk4/m3PGAYdv13oE5AZUhqLyl83VM6Shg2MFx0tbSefVO6BDZ5hBgZ2vCUVa0/xIWAc7MAJpefkvfHjV/oFvhca4KvJprjzOXtXOES3/5OyDZXLCoZ8ibm9bZj1uZttXrLKIWCNf5uEZq8MKK1GGWNH1/PwOY= Message-ID: Date: Fri, 14 Oct 2005 15:22:00 +0100 From: Jared Still To: manoj.gurnani@polaris.co.in Subject: Re: Modify Primary Key Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1114_20971651.1129299720577" References: X-archive-position: 26995 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1114_20971651.1129299720577 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline > > Hi, > What are different steps to be followed in modifying a primary > key(PK1) to exclude last primary key column from a list of primary key > columns. > assuming referential integrity constraints exists on primary key in diff > tables. > give necesary sql syntax to perform the tasks . All the syntax required is found right here: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm FYI: It is generally assumed that the poster of a question will have done a fair amount of research prior to asking a question requesting such a comprehensive answer. I see that Norman took the trouble to answer this. These types of questions often go unanswered if it appears that the poster did not try to answer the question on his own before asking someone else to answer it. BTW, this question is a perfect example of why surrogate keys should be used. The PK should never be modified. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_1114_20971651.1129299720577 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi,
 = ;        What are different steps to be = followed in modifying a primary
key(PK1) to exclude last primary key col= umn from a list of primary key
columns.
assuming referential integrity  constraints exist= s on primary key in diff
tables.
give necesary sql syntax to perform = the tasks .


All the syntax required is found right here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b= 14200/toc.htm

FYI: It is generally assumed  that the poster of a question will have = done a fair amount
of research prior to asking a question requesting such a comprehensive answ= er.

I see that Norman took the trouble to answer this.  These types of que= stions often
go unanswered if it appears that the poster did not try to answer the quest= ion on
his own before asking someone else to answer it.


BTW, this question is a perfect example of why surrogate keys should be use= d.
The PK should never be modified.


--
Jared Still
Certifiable Oracle DBA and Part T= ime Perl Evangelist
------=_Part_1114_20971651.1129299720577-- -- http://www.freelists.org/webpage/oracle-l