Re: Refreshing data on a test database

At 08:01 PM 8/28/97 EDT, you wrote: > >Neil, Truby wrote: >> >> Our users have a requirement for a test database, with the data regularly >> refreshed from production. We achieve this by dbexporting the production >> database, dropping the test one then using dbimport to re-create it. >> > >If your physical layouts are the same, why not restore a production backup to the test >system. That's how we do it. It's a LOT faster than dbexport/dbimport. > Is it possible to do this if the chunk names and numbers are the same but their sizes are different? Our production chunks are larger than our test environment, but both environments are sufficient in size to cover the present amount of production data. Another way of asking this is, what needs to be identical to both environments for a restore of a level-0 archive of my production system to my test system to work? Thanks for you help. Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+