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