Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exports clear of integrity issue

Status
Not open for further replies.

naushi

ISP
Jan 18, 2002
89
US
during the export how do you check intergrity. Is it possible to keep the intergity if one table is exported and a change was made to a related table after the table was exported. e.g if a cascade delete occured for a certain key in a parent table and the parent table was already exported. The child tabel will not show the record but the parent table will show the record if export failed to go back before cloing and check the integrity. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com
 
Include the export parm CONSISTENT=Y. The default is N, so you need to include this parm if you are concerned about updates occurring during your export.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top