Home » Other » General » Data Modification on Personal Orcale 7
Data Modification on Personal Orcale 7 [message #197770] Thu, 12 October 2006 10:49 Go to next message
Messages: 1
Registered: October 2006
Junior Member

I have a database which running on Personal Oracle 7. The database is on going and live. Now, I want to modify my item code. Is it any way/utility able to change particular item code in all tables in one time?
For example, I want to change item code 1002 to 1112. The item code 1002 has been use for many transactions. Manual edit is not possible because of key and link problem. So, I want look for a code/utility which be able to change the item code in all table accordingly, no matter there is key/link issue.

Please help.

Thanks & Regards

Re: Data Modification on Personal Orcale 7 [message #197831 is a reply to message #197770] Thu, 12 October 2006 19:41 Go to previous message
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
It sounds to me like you will have to write custom SQL to create new records with the new value in those tables that use the field as a primary key. Then update the subordinate table entries and then delete the old primary records.

Previous Topic: Failure to enlist in resource Manager
Next Topic: Trial Oracle software?
Goto Forum:

Current Time: Wed Jul 28 06:24:13 CDT 2021