This content has been marked as final. Show 7 replies
Here is a good starting point:
You need EXP_FULL_DATABASE to export from other schemas and IMP_FULL_DATABASE to import into other schemas (this includes SCHEMA_REMAP).
Datapump is authenticated by the user running it, so whether you are running it from a client workstation or OEM or the server (ok, not the server, you'll need to be part of the DBA group for that) datapump will use your Oracle user's permissions.
Datapump creates it's files on the database server so if you want these files in another directory you will have to create and Oracle Directory.
Thank you Andy. It really helped.
Datapump is authenticated by the user running it, so whether you are running it from a client workstation or OEM or the server (ok, not the server, you'll need to be part of the DBA group for that) datapump will use your Oracle user's permissions.Does the user need to be part of DBA group to run data pump utility from server?
It all depends on what you want that user to be able to export/import. If all that use is exporting/importing is their own objects, then they don't need any raised privs. If you want that user to be able to export objects owned by other schemas, then they would need the exp_full_database and in order to import, they would need imp_full_database.1 person found this helpful
Thank you dean. My confusion is when I telnet to the unix machine have oracle to you impdp does that user need to be in oracle dba group.
I'm not sure what you are asking. Are you asking about the unix-user or the oracle-schema?1 person found this helpful
If you are asking about the oracle-schema, I'm not sure what you mean about the dba-group. There is a dba privilege that oracle has defined that you can give to users, but this would give the user full privileges on the database. You do not have to give the oracle_schema that dba privilege unless you want that user to be able to export/import objects from other oracle-schemas.
If you set up the unix system to allow only unix-users that belong to the dba-group to be able to run expdp or impdp, then I would think that you would have to add that group to the unix-users that you want to be able to run expdp/impdp.
Or maybe you are asking a different question?
Sorry about the confusion.
Thank you Dean I was asking if the unix user need to be part of dba group.