Topic: SQL*Plus and PL/SQL >> Modifying the primary keys
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Modifying the primary keys |
| yuva |
Posted: Mar 24, 2005 04:45:32 AM |
Total Post: 2
Joined: Mar, 2005
|
Hi,
I have created a composite primary key say (a,b,c). There are record in that table and there are references also in the other table.
Now I wanted to change the primary key to (b,c,a).
Can someone please guide me how to go about it? |
|
|
 vikas |
| Posted: Mar 25, 2005 09:15:54 AM |  |
|
Total Post: 18
Joined: Jan, 2003
|
I think, you will have to recreate the keys. I dont think, you can alter primary key without recreating them.
Vikas
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 334 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
