I have to use data pump export/import to do the following
- Export *.dmp file for all instances
- login as SYS
- CREATE DIRECTORY pump_dir_trx AS 'd:\temp\pump_dir';
- Explicitly create from DOS prompt the directory d:\temp\pump_dir
- expdp sys DIRECTORY=pump_dir_trx DUMPFILE=wisc.dmp CONTENT=METADATA_ONLY;
I need to know what extra step I need to perform to give Oracle all access to the directory created since in Oracle site, it is written
You must also create a corresponding operating system directory for file storage. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes.
I also need to get the wisc.dmp file after the export is done successfully. Will it be available in 'd:\temp\pump_dir' or someplace else.
If I understand your question, the answer would be to create the directory as the same user that installed Oracle.
Yes, the purpose of the directory is to have a place to put the export, so that's where the file goes, as well as a default for log files and such.
Also, do not use SYS to execute expdp and impdp - you should use SYSTEM account. Pl see the first Note sections in the docs