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 : 27-06-2017

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

  • ora-30072 : invalid time zone value
  • ora-24401 : cannot open further connections
  • ora-13460 : GeoRaster metadata SRS error
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-29526 : created Java class string"string"
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-25209 : invalid value string, EXPIRATION should be non-negative or NEVER
  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-06735 : TLI Driver: client failed to close error conn
  • ora-15183 : ASMLIB initialization error [string]
  • ora-06776 : TLI Driver: error sending parms
  • ora-13126 : unable to determine class for spatial table string
  • ora-13421 : null or invalid cell value
  • ora-30687 : session terminated by debugger
  • ora-29816 : object being disassociated is not present
  • ora-14312 : Value string already exists in partition string
  • ora-13005 : recursive HHCODE function error
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-39052 : cannot specify SKIP_CURRENT on initial start of a job.
  • ora-13359 : extent does not have an area
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-02339 : invalid column specification
  • ora-16108 : database is no longer a standby database
  • ora-27140 : attach to post/wait facility failed
  • ora-32604 : invalid REBUILD option
  • ora-08106 : cannot create journal table string.string
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-13918 : Updating system alert with reason_id string failed; previous alert not found
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-28578 : protocol error during callback from an external procedure
  • 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.