Hi Team,
I have a problem with my testing box. I am running Oracle 10g in that with Windows Platform.
I got a task to export a particular schema.
I have created the directory successfully and granted the permissions too successfully. Still i got this error.
SQL> create directory TESTDUMP_DIR as '/u01/app/oracle'; - succeeded
SQL> grant read,write on directory TESTDUMP_DIR to SCHEMA1; - grant succeeded
$ expdp parfile=schema1.par
When i was trying to do that, i got below error -
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name TESTDUMP_DIR is invalid
I checked the parameter but value is not there.
SQL> show parameter utl_file_dir
NAME
------------------------------------
TYPE
--------------------------------------------------------------------------------
VALUE
------------------------------
utl_file_dir
string
I altered the parameter file but still the value is not getting reflected. Even i restarted the DB. But no use.
SQL> alter system set utl_file_dir='/u01/app/oracle' scope=spfile;
System altered.
Any help will be greatly appreciated. Thanks in Advance.
Thanks
V11081985