Extract particular schema from oracle dump file placed in file server

Question

I have a complete data dump of all the schemas from my database in my local server, but I require a particular schema dump from the main dump file. I know the name of the schema for which I require a separate dump. Is there any way to get it?

I tried the following

expdp User/pwd@db schemas=sample directory=/apps/dpdump dumpfile=sample.dmp logfile=sample.log

but I get the following error:

UDE-00014: invalid value for parameter, 'directory'.

Answer 1

Your schemas parameter looks correct, but the directory parameter is not. The parameter actually refers to an Oracle DIRECTORY object, not the physical path itself. You need to create the directory using the CREATE DIRECTORY command, example:

CREATE DIRECTORY MYDUMP AS 'apps/dpdump';

then reference that in the expdp command as, directory=MYDUMP , etc.

You also may need grants and a synonym created on the directory depending on who needs access to it.