Error in DBCA -> ORA-27059
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error in DBCA -> ORA-27059

Hybrid View

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Error in DBCA -> ORA-27059

    I encountered ORA-27059: skgfrsz: could not reduce file size while creating new database using DBCA. I couldn't get any help from Metalink website as the below is shown:

    Error: ORA-27059
    Text: skgfrsz: could not reduce file size
    -----------------------------------------------
    Cause: ftruncate system call returned error
    Action: check errno

    Where to check error no? What is the workaround? What is the actual problem causing it?

    Thanks.

    DB version: 9.0.1
    OS: Sun Solaris 8

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    The error means that there is not enought space where you are trying to create the datafile...

    Change the path of the datafile to some other location where you have write permission and ample of space. You can modify the path in DBCA or DBASSIST wizard.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width