Oracle manually add an FK constraint
- by Oxymoron
Alright, since a client wants to automate a certain process, which includes creating a new key structure in a LIVE database, I need to create relations between tables.columns.
Now I've found the tables ALL_CONS_COLS en USER_CONSTRAINTS to hold information about constraints. If I were to manually create constraints, by inserting into these tables, I should be able to recreate the original constraints.
My question: are there any more tables I should look into?
Do you have an alternate suggestions, as this sounds VERY dirty and error prone to begin with.
Current modus operandi:
Create a new column in each table for
the PK;
Generate a guid for this PK;
Create a new column in each table for
the FKs;
Fetch the guid associated with the
FK;
....... done sofar......
Add new constraint based on the old
one;
Remove old constraint;
Rename new columns;
This is kind of dodgy and I'd rather change my method, any ideas would be helpful.
To put it different, client wants to change key structure from int to guid on a live database. What's the best way to approach this
