David, We have, in the past, used Databee's free tool successfully to load the subset into the database. Alternatively TOAD also has a little subset tool which is not that functional. But Databee with scripts is, in my opinion , the easiest way to go. My 0.02 $ Tapan Trivedi ----- Original Message ----- From: David Wagoner <mailto:dwagoner@xxxxxxxxxxxxxxxxxx> To: ORACLE-L <mailto:oracle-l@xxxxxxxxxxxxx> (E-mail) Sent: Monday, March 01, 2004 2:37 PM Subject: Methods to Create Smaller Test DB from Production? I know many of you have addressed this same issue... What is a good method to create a smaller test database from Production? I've read about the commercial product called DataBee for doing this, but what other methods are you guys using? With all of the expertise in this list, there are bound to be some interesting solutions. Best regards, David B. Wagoner Database Administrator ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------