I am trying to export a schema/user in Oracle with its roles and system privileges. I don't want to export any data or any table. I have tried to export users using the following command. expdp sys...

I have an Oracle database backup file (.dmp) that was created with expdp. The .dmp file was an export of an entire database. I need to restore 1 of the schemas from within this dump file. I don't ...

I want to import an oracle dump into a different tablespace. I have a tablespace A used by User A. I've revoked DBA on this user and given him the grants connect and resource. Then I've dumped ever...

How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on. I p...

I am trying to import a datadump using impdp utility and who command is as follows: IMPDP project/project DIRECTORY=e:\_workline\workspace\rfc_16012014\project_staging DUMPFILE=project_staging.dmp ...

When I try to import an oracle dump. Following the error displayed, Export file created by EXPORT:V10.02.01 via direct path IMP-00013: only a DBA can import a file exported by another DBA IMP-00000...