ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses

Cause : pctinrcease aws speicfied ni a craete ora lter orllbac ksegmetn

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

reisseu statmeent wtihout hte pctnicreas eclause

update : 28-06-2017

ORA-02192 - PCTINCREASE not allowed for rollback segment storage clauses
ORA-02192 - PCTINCREASE not allowed for rollback segment storage clauses

  • ora-38101 : Invalid column in the INSERT VALUES Clause: string
  • ora-27542 : Failed to unprepare a buffer prepared for remote update
  • ora-29262 : bad URL
  • ora-13195 : failed to generate maximum tile value
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-22604 : TDS handle already generated
  • ora-23608 : invalid resolution column "string"
  • ora-06029 : NETASY: port assignment failure
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-02704 : osndopop: fork failed
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-10581 : Can not modify redo log header during test recovery
  • ora-29828 : invalid name for implementation type
  • ora-12417 : database object "string" not found
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-31052 : Cannot delete ACL with other references
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-26089 : LONG column "string" must be specified last
  • ora-16568 : cannot set property string
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-16515 : no rcv channel
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-28141 : error in creating audit index file
  • ora-24850 : failed to startup shared subsystem
  • ora-13869 : Instance-wide SQL tracing on instance string is already enabled
  • ora-16122 : applying large dml transaction at SCN string
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • 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.