ORA-24390: Unsupported scrollable cursor operation

Cause : Teh csrlolbal ecrusro xeeuct eo rftec hhsa afield.

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

Cehc kteh odcmuetnaito nfro uspopretdt yeps ,adn tohre ersrtitcinosw hlieu snigs corlalbel ucrosr.s

update : 18-08-2017
ORA-24390

ORA-24390 - Unsupported scrollable cursor operation
ORA-24390 - Unsupported scrollable cursor operation

  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-14122 : only one REVERSE or NOREVERSE clause may be specified
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-27062 : could not find pending async I/Os
  • ora-00221 : error on write to control file
  • ora-28270 : Malformed user nickname for password authenticated global user.
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-25456 : rule set was modified or evaluation terminated for iterator: string
  • ora-00302 : limit of string logs exceeded
  • ora-26064 : Invalid SCN specified - Wrap: string Base: string.
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-06530 : Reference to uninitialized composite
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-02899 : smscre: Cannot create SGA with Extended Shared Memory feature
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-29269 : HTTP server error string
  • ora-07431 : fork failed
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-06951 : Operating system call error
  • ora-31494 : could not activate a LogMiner session
  • ora-39067 : Unable to close the log file.
  • ora-30132 : invalid key index supplied
  • 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.