You executed the following command to export the EMPLOYEES table from a remote machine:
$ EXPDP hr/[email protected]
DUMPFILE=my_dir:exp_hr.log
LOGFILE=data_pump_dir:log_hr.log
TABLES=employees
What would be the outcome of this command?
A.
The command would execute successfully. But log file would not be created as DATA_PUMP_DIR directory is only accessible to user with SYSDBA privilege.
B.
The command fails with an error because no absolute path is specified for log file and dumpfile.
C.
The command would execute successfully and the export dump file would be created in the destination of the directory object MY_DIR.
D.
The command fails with an error because DATA_PUMP_DIR directory have higher precedence over the per-file directory.