Unix/Linux Go Back    


UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics.

Problem in import & expdp Dump file

UNIX and Linux Applications


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 03-12-2015
clerck clerck is offline
Registered User
 
Join Date: Mar 2015
Last Activity: 12 March 2015, 9:04 AM EDT
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Problem in import & expdp Dump file

Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.

[root@srv1 mohamed]# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y



Export: Release 11.2.0.1.0 - Production on Thu Mar 12 09:27:09 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


the steps i had made on SQLpluse:

1-CREATE DIRECTORY test AS '/u01/backup/testdump';

GRANT read, write ON DIRECTORY test to system;
Sponsored Links
    #2  
Old Unix and Linux 03-12-2015
cero cero is offline
Registered User
 
Join Date: Aug 2006
Last Activity: 29 March 2017, 8:55 AM EDT
Posts: 450
Thanks: 4
Thanked 98 Times in 90 Posts
Does the OS-user the Oracle instance runs under have write permission on the directory?
Sponsored Links
    #3  
Old Unix and Linux 03-12-2015
clerck clerck is offline
Registered User
 
Join Date: Mar 2015
Last Activity: 12 March 2015, 9:04 AM EDT
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
oracle user can access /u01/backup/testdump & have permission to write on this path "i test create new file on this path by oracle user ""
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to import and dump file to remote Oracle server? Palak Sharma UNIX and Linux Applications 3 07-16-2014 06:30 PM
How can I import a particular schema from full dump in Oracle? Palak Sharma UNIX for Dummies Questions & Answers 6 05-19-2014 05:53 AM
How to Import dump file with default value for single column? GOVINDARAJ.M UNIX for Dummies Questions & Answers 6 06-04-2013 10:01 AM
Zip dump file using expdp: qwertyu Shell Programming and Scripting 8 01-07-2013 05:15 AM
Import dump to database agarwal UNIX for Dummies Questions & Answers 2 06-27-2011 07:51 AM



All times are GMT -4. The time now is 12:40 AM.