oracle邏輯匯入小錯：提示無法建立日誌提示

標籤：imp   小問題   邏輯備份   

***********************************************聲明*********************************************************************** 

原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/39695171

****************************************************************************************************************************
oracle邏輯匯入提示無法建立日誌提示小問題解決

[[email protected] soft]$ imp hyl/[email protected] fromuser=hyl touser=hyl feedback=10000 filesize=15G ignore=y commit=y file=/soft/test.dmp log=/soft/testImp.log

Import: Release 11.2.0.4.0 - Production on Fri Sep 19 16:30:04 2014

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

IMP-00030: failed to create file /soft/testImp.log for write
IMP-00000: Import terminated unsuccessfully

由報錯很容易發現問題所在，修改許可權，然後再執行，如下操作：
[[email protected] /]# chown -R oracle:oinstall /soft

修改許可權後，再次執行匯入操作，成功完成，如所示：
[[email protected] soft]$ imp hyl/[email protected] fromuser=hyl touser=hyl feedback=10000 ignore=y file=/soft/test.dmp log=/soft/testImp.log

Import: Release 11.2.0.4.0 - Production on Fri Sep 19 16:38:29 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)

***********************************************聲明*********************************************************************** 

原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/39695171

****************************************************************************************************************************

oracle邏輯匯入小錯：提示無法建立日誌提示