Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 488

Posted by Hendry chinnapparaj on February 4, 2011

Problem

————–

When doing export form datapump

ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 488

Solution

————–

create the unix directory and the data pump directory in oracle

DROP DIRECTORY DATA_PUMP_DIR;

 

CREATE OR REPLACE DIRECTORY

DATA_PUMP_DIR AS

‘/u01/oracle/admin/msoa1_js/dpdump/’;

 

 

GRANT READ, WRITE ON DIRECTORY SYS.DATA_PUMP_DIR TO dp WITH GRANT OPTION;

 

GRANT READ, WRITE ON DIRECTORY SYS.DATA_PUMP_DIR TO EXP_FULL_DATABASE;

 

GRANT READ, WRITE ON DIRECTORY SYS.DATA_PUMP_DIR TO IMP_FULL_DATABASE;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: