ORA-27059: could not reduce file size

Cause : ftruncate system call returned error

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

check errno

update : 29-06-2017
ORA-27059

ORA-27059 - could not reduce file size
ORA-27059 - could not reduce file size

  • ora-31090 : invalid database schema name "string"
  • ora-13416 : invalid geometry parameter
  • ora-19209 : invalid or unsupported formatting argument
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-13007 : an invalid HEX character was detected
  • ora-31186 : Document contains too many nodes
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-39016 : Operation not supported when job is in string state.
  • ora-13373 : invalid line segment in geodetic data
  • ora-01194 : file string needs more recovery to be consistent
  • ora-27048 : skgfifi: file header information is invalid
  • ora-00406 : COMPATIBLE parameter needs to be string or greater
  • ora-39086 : cannot retrieve job information
  • ora-01183 : cannot mount database in SHARED mode
  • ora-31122 : The string operator has incorrect RHS value
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-38311 : cannot purge objects owned by other users
  • ora-16098 : inaccessible standby database forced shutdown to protect primary
  • ora-25468 : column name not specified for alias: string
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • ora-28533 : Heterogeneous Services coercion handling error
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-02842 : Client unable to fork a server
  • ora-28234 : key length too short
  • ora-01500 : failure in getting date/time
  • ora-29315 : tablespace 'string' has been recreated
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.