Question: I am getting the
following errors when attempting to run import impdp using
the network_link option:
C:>impdp example/example@db DIRECTORY=DATA_PUMP_DIR
NETWORK_LINK=db.legal.regn.net remap_schema=BI:example
tables=BI.BI_DIRECT dumpfile=BI.dmp
logfile=BI.log
Got the following errors :
ORA-39002: invalid
operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
The directory I created (DATA_PUMP_DIR) shows read-only
in the general tab of the property.
Answer: You want to test your
database link first, and make sure that you have
connectivity to the remote server. See these notes on
creation and setup for the
network_link parameter.
Oracle shows this as a root cause of your impdp failure:
ORA-29283: "invalid file operation"
Cause: An attempt was made to read from
a file or directory that does
not exist, or file or
directory access was denied by the
operating system.
Action: Verify file and directory
access privileges on the file system,
and if reading,
verify that the file exists.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
