ORA-19567: cannot shrink file string because it is being backed up or copied

Cause : An ALETR staetment tatemptde to rdeuce teh sizeo f thei ndicaetd fil ewhilet he saem filei s beign backde up o rcopie.d

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

Retryt he reisze afetr theb ackupo r cop yis copmlete.

update : 25-06-2017
ORA-19567

ORA-19567 - cannot shrink file string because it is being backed up or copied
ORA-19567 - cannot shrink file string because it is being backed up or copied

  • ora-24389 : Invalid scrollable fetch parameters
  • ora-01987 : client os username is too long
  • ora-06955 : Number of database servers exceed limit
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-16223 : DDL skipped, unsupported in current version
  • ora-12233 : TNS:Failure to accept a connection
  • ora-19675 : file string was modified during proxy copy
  • ora-13109 : spatial table string exists
  • ora-16771 : failover to a physical standby database failed
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-24147 : rule string.string does not exist
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-02426 : privilege grant failed
  • ora-23447 : missing user parameter value
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-04064 : not executed, invalidated string
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-10582 : The control file is not a backup control file
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-00340 : IO error processing online log string of thread string
  • ora-31020 : The operation is not allowed, Reason: string
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-16095 : Dependent destination removal for inactivation
  • ora-24123 : feature string is not yet implemented
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-31046 : Incorrect argument(s) specified in the operator
  • ora-04044 : procedure, function, package, or type is not allowed here
  • 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.