ORA-02300: invalid value for OIDGENERATORS

Cause : A number was not specified for the value of OIDGENERATORS.

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

Specify a number for OIDGENERATORS.

update : 26-09-2017
ORA-02300

ORA-02300 - invalid value for OIDGENERATORS
ORA-02300 - invalid value for OIDGENERATORS

  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-34000 : (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.
  • ora-12518 : TNS:listener could not hand off client connection
  • ora-02336 : column attribute cannot be accessed
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-16063 : remote archival is enabled by another instance
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-24399 : invalid number of connections specified
  • ora-32140 : cannot peform this operation on stream
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-28665 : table and partition must have same compression attribute
  • ora-31446 : this session does not own the lock handle for string
  • ora-07581 : spstp: cannot derive SID from unexpected process name
  • ora-01424 : missing or illegal character following the escape character
  • ora-12209 : TNS:encountered uninitialized global
  • ora-32310 : object materialized views must select from an object table
  • ora-31059 : Cannot insert root XML document node if it already exists
  • ora-09753 : spwat: invalid process number.
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-14619 : resulting List subpartition(s) must contain at least 1 value
  • ora-24098 : invalid value string for string
  • ora-26763 : invalid file type "string"
  • ora-28100 : policy function schema string is invalid
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-12234 : TNS:Redirect to destination
  • ora-38712 : Corrupt flashback log record header: block string, offset 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.