Oracle导入(imp)导出(exp)出现“ IMP-00030 failed to create file import_sys for write ” 错误

0    200    1

Tags:

👉 本文共约480个字,系统预计阅读时间或需2分钟。

[oracle@rac18c-n1 upraw_oracle11g]$ imp xxxx file=raw.dmp ignore=y grants=no fromuser=UPRAW touser=UPCHINA

Import: Release 18.0.0.0.0 - Production on Tue Dec 4 15:01:38 2018

Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

Export file created by EXPORT:V11.02.00 via direct path

Warning: the objects were exported by UPRAW, not by you

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

export client uses AL32UTF8 character set (possible charset conversion)

IMP-00030: failed to create file import_sys for write

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

IMP-00000: Import terminated unsuccessfully

原因:

oracle 账户没有对指定目录的读/写权限

解决办法:

更换到Oracle有读写权限的相关目录

[root@rac18c-n1 ~]# chown -R oracle.dba /soft/oracle11g/oracle11g/upraw_oracle11g

[root@rac18c-n1 ~]# chmod 777 -R /soft/oracle11g/oracle11g/upraw_oracle11g

[root@rac18c-n1 ~]#

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

3 + 7 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部