ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

Cause : Ani nvlaidv aleu sepciifedf orp armaetre VSIIBLIIT.Y

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

Spceif yeihterO N_OCMMTI o rIMEMDITAE.

update : 18-08-2017
ORA-25201

ORA-25201 - invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
ORA-25201 - invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

  • ora-13237 : internal error during R-tree concurrent updates: [string]
  • ora-09263 : spini: error initializing process
  • ora-31651 : communication error with master process - detaching job
  • ora-02492 : missing required file block increment size in NEXT clause
  • ora-39103 : Timeout before worker process string finished initialization. Worker error:
  • ora-36842 : (XSLMGEN12) Hierarchy string.string!string.string was not found
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-12853 : insufficient memory for PX buffers: current stringK, max needed stringK
  • ora-29840 : indextype and implementation type are not in same schema
  • ora-25952 : join index must only contain inner equi-joins
  • ora-31420 : unable to submit the purge job
  • ora-00375 : unable to get default db_block_size
  • ora-00912 : input parameter too long
  • ora-22922 : nonexistent LOB value
  • ora-19030 : Method invalid for non-schema based XML Documents.
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-32059 : deadlock detected on mapping structures
  • ora-13215 : window object is out of range
  • ora-10634 : Segment is already being shrunk
  • ora-38465 : failed to create the privilege checking trigger due to: string
  • ora-14013 : duplicate partition name
  • ora-19709 : numeric parameter must be non-negative integer
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-26733 : timed-out waiting for file group lock
  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-31029 : Cannot bind to unsaved resource
  • ora-39708 : component 'string' not a string component
  • ora-30111 : no closing quote for value 'string'
  • ora-01779 : cannot modify a column which maps to a non key-preserved table
  • 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.