Trang,
Could you be a little bit more specific about what you are
trying to do?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Meomeo Nguyen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, May 29, 2002 7:05
PM
Subject: how to
Trang,
How
about:
alter
tableTABLE_NAME drop constraint CONSTRAINT_NAME;
alter
table TABLE_NAME add constraint pk_TABLE_NAME primary key
(COLUMN)
using
index tablespace indexes;
-Original Message-From: Meomeo Nguyen
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 29, 2002 7:06
Hi Igor,
I just wanted to set a concatenated keys for my table. By mistake, I assigned only one primary key instead of two combined together.
Here is my table structure:
organization_id (primary key)
address_id (foreign key) It should have been a primary key as well. I wanted to set this