3 Replies Latest reply: Jan 3, 2013 12:02 PM by Srini Chavali-Oracle RSS

    Impport *.dmp file from PROD to QA (METADATA_ONLY)

    amitavachatterjee1975
      Hi Gurus,

      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.

      Thanks
      Amitava.