Home » RDBMS Server » Server Utilities » SYS.UTL_FILE Error in Oracle 10g
SYS.UTL_FILE Error in Oracle 10g [message #207383] Tue, 05 December 2006 05:33 Go to next message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


The export command failure in Oracle 10g windows,

How to resolve the prblem?

D:\oracle\product\10.1.0\admin>expdp scott/tiger@orcl1 schemas=SCOTT directory=TEST dumpfile=Test.DMP logfile=Test.log

Export: Release - Production on Tuesday, 05 December, 2006 17:01

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

Connected to: Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining 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


Babu B

[Updated on: Wed, 06 December 2006 00:14]

Report message to a moderator

Re: Export Error [message #207387 is a reply to message #207383] Tue, 05 December 2006 05:42 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
You should ensure that TEST directory object is created and you have been granted privileges to this directory.
Previous Topic: How to get a db report in worddoc format??
Next Topic: SQL LOADER
Goto Forum:

Current Time: Thu Oct 20 19:49:50 CDT 2016

Total time taken to generate the page: 0.05177 seconds