Re: Import all data from prod to test

be aware of the ramifications of putting prod data in a test environment.
think about obfuscating sensitive stuff.  my gummint now considers someone's
hat size and chewing gum preference as privileged and confidential.



"Frank" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [EMAIL PROTECTED] wrote:
> > Hi,
> >
> > I want to export/import all my data from prod to test database.
> > I have more then 50 schemas in my database, therefore fromuser touser is
not
> > what I want. Otherwise export and import full database will
export/import sys
> > object as well - it's overwrite the sys objects in test database.
> >
> > Any ideas how to make this?
> >
> > Thanks in advance
> >
> > Olaf
> Normally one does full exports as system; it's up to you
> to decide which schema's to import, using fromuser touser,
> or import all, by importing as system
>
> --
> Regards, Frank van Bortel
>