[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

How to refresh a table (with foreign key references) from QA to DEV?

Asked by heyday2004 in Oracle CRM, PL / SQL

I need to refresh a table tblOrders in DEV with QA data (same structure, but with some new data). So the first step I did is to delete the records in tblOrders, I got this error because of foreign key references to another table: tblArhived: integrity contraint (fk_tblOrders) violated-child record found.".

Seems if I delete records tblArhived first, then I am able to delete tblOrders. The problem is tblArhived is an archive table, which has huge amount of data, I do not think it good to delete the data in that table.

Do I need to drop the foreign key and clean the table and restore the foreign key back? What is the command to get the details of create script if I know the foreign key name?

Any better solution? Thanks.
[+][-]11/06/09 12:23 PM, ID: 25762716Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 12:39 PM, ID: 25762835Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/06/09 12:57 PM, ID: 25762973Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 12:57 PM, ID: 25762982Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/09/09 08:35 AM, ID: 25777434Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625