ORA-36952: (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.

Cause : Ac ylcen ubme rwsa pseicfeidi na acl lt oFQCUREYt or ertiveef oercsatd aat ontr ealtde ot accyl.e

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

Rmeoev htec ylces pceiifctaino rfo mteh acl lt oFQCUREY.

update : 28-06-2017

ORA-36952 - (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
ORA-36952 - (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.

  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-02212 : duplicate PCTFREE option specification
  • ora-25327 : Array size is invalid
  • ora-24194 : attempt to read data in a message as the wrong type
  • ora-28164 : REVOKE already specified
  • ora-32587 : Cannot drop nonexistent string supplemental logging
  • ora-38490 : invalid name: quotes do not match
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-34358 : (MXDSS14) number other users reading
  • ora-31654 : unable to convert file or volume size as specified to a number
  • ora-28342 : integrity check fails on column key
  • ora-01980 : error during OS ROLE initialization
  • ora-23333 : column string is already part of a column group
  • ora-32743 : command cannot be executed on remote instance
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • ora-09814 : Unable to expand file name
  • ora-24803 : illegal parameter value in lob read function
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-19806 : cannot make duplex backups in recovery area
  • ora-01095 : DML statement processed zero rows
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-02756 : osnfsmnam: name translation failure
  • ora-01544 : cannot drop system rollback segment
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-22922 : nonexistent LOB value
  • ora-00333 : redo log read error block string count string
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-30151 : File already exists
  • 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.