SYS.UTL_FILE Error in Oracle 10g [message #207383] |
Tue, 05 December 2006 05:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
![babu.knb@gmail.com](/forum/theme/orafaq/images/google.png) ![babudba](/forum/theme/orafaq/images/skype.png)
|
|
Hi,
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 10.1.0.2.0 - Production on Tuesday, 05 December, 2006 17:01
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 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
Regards
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/85219.jpg) |
ebrian
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.
|
|
|