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 : 20-08-2017
ORA-02211

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

  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-02790 : File name is too long
  • ora-06733 : TLI Driver: failed to receive disconnect
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-29281 : invalid mode
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-29906 : indextype string.string does not exist
  • ora-38442 : The ADT "string" is not in a valid state.
  • ora-22920 : row containing the LOB value is not locked
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-09210 : sftopn: error opening file
  • ora-30457 : 'string.string' cannot be refreshed because of unmnanaged NOT NULL columns in container
  • ora-12540 : TNS:internal limit restriction exceeded
  • ora-13029 : Invalid SRID in the SDO_GEOMETRY object
  • ora-02218 : invalid INITIAL storage option value
  • ora-07492 : scgrcl: cannot close lock.
  • ora-19904 : test recovery not allowed for datafile string
  • ora-06138 : NETTCP: error during connection handshake
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-06042 : NETDNT: message receive failure
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-30194 : reserved for future use
  • ora-29890 : specified primary operator does not have an index context
  • ora-25336 : Cannot contact instance string during Streams AQ operation
  • ora-16529 : bad sender id
  • ora-25125 : BUFFER_POOL storage option not allowed
  • 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.