Sean, I've done houndreds of exports with consistent=y and it works like a charm. Even in heavy loaded production systems. If oracle is not able to do a consistent export you will get appropriate error messages. Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Garrison, Sean (Norcross) Gesendet: Donnerstag, 24. September 2009 14:35 An: arslist@ARSLIST.ORG Betreff: Help with exporting an Oracle DB .... ** We have a 24x7 remedy system that runs on an Oracle DB. We are trying to get an export from production into our lower environments. We are unable to just lock out users in order to do an export. Whenever we try to do this the count of the "T" vs "H" tables are different. Basically what is happening is oracle is exporting the "H" tables first and then later gets to the "T" tables. In between the exports new records were created on a form which causes the "T" tables to have more records than the "H" tables do. There is an option called "Consistency=Yes" when doing an export that is supposed to go back and synch up all of the data but from our experience that isn't happening. The export doesn't have to be real-time but does have to have consistent data. I was wondering if there was a way to pass in an date into the export file so that no records created after a certain date get included -- or something to that effect. Any suggestions or ideas on how to get an Oracle export of a Remedy db? Thanks, Sean Michael (Sean) Garrison Remedy Developer - Senior Enterprise Technology Fiserv Phone: 678-375-1089 Mobile: 770-851-8238 Fax: 678-375-3434 www.fiserv.com <http://www.checkfree.com> P Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"