LM2011
Last Activity: Jan 29 '12, 09:40 AM
Joined: Dec 12 '11
Location:
-
Thank you very much^_^ -
"You could just drop the primary key and create your new one on the same table". I can drop the primary key and create a new composite key on the same table(the old one), and just start to insert new records, and this do not affect the old records, right?Leave a comment:
-
First, thank you for your reply.Well, I mean I want to change the one PK table into a two-PK table. By the way, I already built an index on the column which has the primary key constraint. Can I still do that?
For example:
create table TEST_T_OLD
(
TEST_ID VARCHAR2(56) not null ,
TEST_NAME VARCHAR2(130),
... ,
TEST_FLAG VARCHAR2(64)...Leave a comment:
-
Can I add another PK to the existed table?
Hi,here's the thing:
I have an existed table(many records have been inserted into it) which already has a PK, but now I want to insert records with the same id, can I just add another PK to realize this?
I hope someone can help me out.thanks ^_^
No activity results to display
Leave a comment: