troubleshooting Question

Oracle 10g RAC - problem extracting data from directory

Avatar of joaotelles
joaotellesFlag for United States of America asked on
Oracle Database
4 Comments1 Solution688 ViewsLast Modified:

I created a directory for Orcale.. see below:

SQL> create directory MIGRATION as '/dataexport';
Directory created.
SQL> grant read ,write on directory MIGRATION to dpownera;
Grant succeeded.

SQL> select * from dba_directories;
OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH
------------------------------ ------------------------------ --------------------
SYS                            TEST_MIG                       /dataexport
SYS                            MIGRATION                      /dataexport
SYS                            DUMP_DIR                       /var/tmp/dump/
SYS                            WORK_DIR                       /ade/aime_stath10/oracle/work
SYS                            ADMIN_DIR                      /ade/aime_stath10/oracle/md/admin
SYS                            ORACLE_OCM_CONFIG_DIR          /u01/app/oracle/product/10.2.0/db_1/ccr/state
SYS                            BACKUPDIR                      /tmp/dump
SYS                            DATA_PUMP_DIR                  /u01/app/oracle/product/10.2.0/db_1/rdbms/log/

8 rows selected.


The erro Im getting is this one...:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation

WHat could this mean?

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros