If the schema has any complexity then manually identifying and extracting the required dependent records can be quite troublesome. There is a white paper on the DataBee web site entitled "Test Database Generation and Management" that discusses the issues in some detail.
http://www.databee.com/TestDBGenWhitePaper.pdf We also provide an automated tool designed for the purpose of creating referentially correct subsets of data. It may be useful in your case. Kind regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] http://www.DataBee.com > I need your advise , currently our customer have a production and > development system , if there is a problem log being raise , > then we need > to > port the data from development to production but not the > whole database > sometime is only certain record. > > Is there any method to use instead of generate insert statement for > necessary table(PROD) and run the statement (DEV) ? > > I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
