Re: refresh test from prod in wrong way

soalvajavab1_at_yahoo.com wrote:
> in our company everytime they refresh the test from production, all the
> user accounts will be gone!
>
> what is the typical way of refreshing a test db from prod? How do you
> avoid this problem typically?

First you recognize that Oracle is not static. That the product, and its features, change from version to version.

Then you repost your question supplying the information required for someone to give you an answer such as:

1. Platforms and operating systems
2. Oracle versions and editions
3. Quantity of data in question
4. Available window (amount of time) to refresh

I don't know whether to suggest a DB Link or transportable tablespaces or RMAN or Streams or Data Guard or .... export/import or DataPump, or a flat file, or ....

You get the point. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org