Re: Import all data from prod to test

[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