ORA-02211: invalid value for PCTFREE or PCTUSED

Cause : hT epscefiei davul eof rCPFTER EroP TCSUDEi son tnai tngereb teewne0 a dn1 00.

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

hCooesa nparppoirta eavul eof rht epoitno.

update : 26-06-2017

ORA-02211 - invalid value for PCTFREE or PCTUSED
ORA-02211 - invalid value for PCTFREE or PCTUSED

  • ora-16649 : database will open after Data Guard broker has evaluated Fast-Start Failover status
  • ora-01588 : must use RESETLOGS option for database open
  • ora-16661 : the standby database needs to be reinstated
  • ora-09802 : Conversion of binary label to string failed.
  • ora-08108 : may not build or rebuild this type of index online
  • ora-30129 : invalid function argument received
  • ora-06592 : CASE not found while executing CASE statement
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-14501 : object is not partitioned
  • ora-13517 : Baseline (id = string) does not exist
  • ora-06805 : TLI Driver: could not send datagram SAP packet for SPX
  • ora-13758 : "SQL Tuning Set" "string" owned by user "string" is in use.
  • ora-13016 : specified topology [string] is invalid
  • ora-09703 : sem_release: cannot release latch semaphore
  • ora-16060 : Log file is current
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • ora-24396 : invalid attribute set in server handle
  • ora-30678 : too many open connections
  • ora-31627 : API call succeeded but more information is available
  • ora-31482 : invalid option for non-distributed Hotlog change source
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-26028 : index string.string initially in unusable state
  • ora-28044 : unsupported directory type
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-09832 : infoCallback: bad message format.
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-38733 : Physical size string less than needed string.
  • ora-04080 : trigger 'string' does not exist
  • 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.