schema export/import [message #329165] |
Tue, 24 June 2008 06:31 |
meggens
Messages: 57 Registered: February 2007 Location: Netherlands
|
Member |
|
|
Hi,
I have following challange:
1. Make a user dump from production database and copy this dump to test system.
2. The customer himself want to perform an import when he thinks it's time to do so.
I was thinking about following solution:
1.datapump export on the production system
2.drop the user cascade
4.datapump import on the test system.
5.perform some grants on sys objects to the user.
The user doesn't have any administrative permissions on the test database so I think I should create a procudure for the datapump import under an administrative user and grant execute permissions to the customer on the procedure. I can also do the grants on the sys objects within this procedure I think.
Is this the way to do this or are there other ways around. Important is that the user himself can start the import whitout having to much privileges. The customer is only having Oracle Net access to the database server.
Best regards,
Martin
|
|
|