| SYS.UTL_FILE Error in Oracle 10g [message #207383] |
Tue, 05 December 2006 05:33  |
babuknb
Messages: 1736
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  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
