Home » RDBMS Server » Server Utilities » schema export/import (10gR2 Standard Editon on Linux)
schema export/import [message #329165] Tue, 24 June 2008 06:31
Messages: 57
Registered: February 2007
Location: Netherlands

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,

Previous Topic: Importing from Excel file into Oracle DB table
Next Topic: Import - views/synonyms
Goto Forum:

Current Time: Sun Oct 23 11:31:50 CDT 2016

Total time taken to generate the page: 0.05508 seconds