ORA-39002: invalid operationORA-39070: Unable to open the log file.

    xiaoxiao2026-09-28  11

    [oracle@orcl admin]$ expdp system/123d@orcl directory= dpdata1 dumpfile=dove20160814.dmp SCHEMAS=dove Export: Release 11.2.0.1.0 - Production on Tue Aug 16 18:51:44 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing 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 536

    ORA-29283: invalid file operation

    解决办法:

    SQL> create or replace directory dpdata1 as '/u01/app/oracle/backup'; Directory created.

    转载请注明原文地址: https://ju.6miu.com/read-1312404.html
    最新回复(0)