Home » RDBMS Server » Server Utilities » Expdp failed - when using mapped drive. (Oracle 10.2.0.3.0)
Expdp failed - when using mapped drive. [message #395337] Wed, 01 April 2009 03:13 Go to next message
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
Member

Hi,

I am facing error ,while executing expdp a mapped drive.

Path : \\xx.xx.xx.xx\DataBaseBackup\--- > mapped as O:\ drive

Directory created in database ,

create directory expdp as 'o:\exportbackup';
grant read,write on directory expdp to system;

Directory : EXPDP
path : O:\ExportBackup\


C:\>expdp system/*******@testdb directory=EXPDP full=y dumpfile=testdb.dmp logfile=testdb.log

Export: Release 10.2.0.3.0 - Production on Monday, 23 March, 2009 22:10:31

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc
tion
With the Partitioning and OLAP 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 475
ORA-29283: invalid file operation


Regards
Ravikumar.V
Re: Expdp failed - when using mapped drive. [message #395353 is a reply to message #395337] Wed, 01 April 2009 03:40 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ORA-39070: Unable to open the log file

Check why this: directory, privileges...

Regards
Michel
Previous Topic: SQL Loader Referencing field problem
Next Topic: SQLLDR
Goto Forum:
  


Current Time: Mon Dec 23 19:36:42 CST 2024