Oracle logic import error: the error message "cannot create logs" is displayed. The error message "oracle logic import" is displayed.

Source: Internet
Author: User

Oracle logic import error: the error message "cannot create logs" is displayed. The error message "oracle logic import" is displayed.

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

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/39695171

**************************************** **************************************** **************************************** ****
Oracle logic import prompt cannot create log prompt small problem solved


[Oracle @ hyldb soft] $ imp hyl/hyl @ hyl 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,201 1, Oracle and/or its affiliates. All rights reserved.


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


If an error is reported, you can easily find the problem. Modify the permission and perform the following operations:
[Root @ hyldb/] # chown-R oracle: oinstall/soft


After modifying the permission, execute the import operation again. The operation is successful, as shown in:
[Oracle @ hyldb soft] $ imp hyl/hyl @ hyl 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,201 1, 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)

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

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/39695171

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


Oracle log prompt: the storage space is insufficient. You cannot process this command.

Your operating system should be 32-bit. memory_target cannot exceed 1.7 GB. the space occupied by sga is fixed by parameters. When the number of connections exceeds a certain number, if you cannot allocate a new pga to a session, an error will be reported. You can try to lower the sga

Windows 7 is installed in oracle 10 Gb, but a directory cannot be created during database creation, so the database cannot be created eventually.

The File Permission of win7 is incorrect. You can add your computer users to the file security. Many users with their own definitions are restricted when Windows 7 is installed, if the ADMINISTRATOR user is used, no problem occurs.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.