Shulou(Shulou.com)06/01 Report--

Showed up this morning when importing using the data pump.

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

Query the directory does exist, and I established it the day before, but when I looked at the directory permissions, I found that

Command to create a directory:

Create directory dir as'/ data/backup'

Grant read,write on directory dir to public

There was a problem viewing permissions:

Drwxr-xr-x 2 root root 4096 12-08 23:07 backup

Drwxrwxrwx 2 oracle oinstall 4096 12-08 23:23 database

Drwx- 2 root root 16384 12-06 18:57 lost+found

The backup directory should belong to oracle:oinstall

Import successfully after modification is completed by using the command chown-R oracle:oinstall / data/backup

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.