Re: Way of extracting record

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.
Dale_at_DataBee.com
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: Dale_at_DataBee.com

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: ListGuru_at_fatcity.com (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).