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
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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
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.
Previous Topic: How to get a db report in worddoc format??
Next Topic: SQL LOADER
Goto Forum:
  


Current Time: Wed Dec 07 03:08:33 CST 2016

Total time taken to generate the page: 0.20917 seconds