hello,
I have a problem and am wondering if anyone has got any ideas about how I should tackle it.
I have two tables : INSTRUMENT and CROSS_REFERENCE, the primary key in the INSTRUMENT table, it has 3 columns in it, is also an foreign key in the CROSS_REFERENCE table. I need to write a job that swaps the primary key of one instrument witht he primary key of another.
Currently I do it manually, and I am not allowed to turn off the constraints, or have a temporary table to load the data into. I had thought of using PL/SQL tables to sore the rows and manipulate them in there . Im using 7.3.4
Does anyone have any ideas
I have a problem and am wondering if anyone has got any ideas about how I should tackle it.
I have two tables : INSTRUMENT and CROSS_REFERENCE, the primary key in the INSTRUMENT table, it has 3 columns in it, is also an foreign key in the CROSS_REFERENCE table. I need to write a job that swaps the primary key of one instrument witht he primary key of another.
Currently I do it manually, and I am not allowed to turn off the constraints, or have a temporary table to load the data into. I had thought of using PL/SQL tables to sore the rows and manipulate them in there . Im using 7.3.4
Does anyone have any ideas