Copy data from Production environment to Test environment

EricS is absolutely correct.

Be sure of the customized tables; suppose if you are copying the complete data along with the tables structure, then if you any new custom tables defined in your test servers will be gone.

Here is how I refresh data in a product line on the test server, with all data from the prod product line on the production server (Our DB is Oracle)... On Lawson Test App Sever: Delete tables and data in : bldora10ddl -UD On DB Server Export ORACLE_SID=PROD (or whatever your production instance SID is) Export data : exp file=prod.dmp owner=LAWPROD (<--prod database user name) statistics=none indexes=n log=exp.log On DB Server export ORACLE_SID=TEST Import data : imp file=prod.dmp fromuser=LAWPROD touser=LAWTEST (<--test database username) statistics=none indexes=none rows=y log=imp.log On Lawson Test App Server Build Indexes bldora10ddl -URI On Lawson Test App Server Verify Database is Valid verifyora10