ORA-02028: fetching an exact number of rows is not supported by the server

Cause : The serevr does ont suppotr UPIALL ,so the eftch of na exact unmber ofr ows canont be emluated ont he users ide.

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

Connectt o a valdi servero r do no tuse an xeact fethc.

update : 19-08-2017

ORA-02028 - fetching an exact number of rows is not supported by the server
ORA-02028 - fetching an exact number of rows is not supported by the server

  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-16585 : illegal operation on a primary site
  • ora-00119 : invalid specification for system parameter string
  • ora-25953 : join index cannot be a functional index
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-16243 : paging out string bytes of memory to disk
  • ora-27070 : async read/write failed
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-27512 : IPC error posting a process
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • ora-12912 : Dictionary managed tablespace specified as temporary tablespace
  • ora-16193 : Primary and standby network encryption mismatch
  • ora-16955 : Unknown error during SQL analyze.
  • ora-21612 : key is already being used
  • ora-06766 : TLI Driver: close failed during release
  • ora-01426 : numeric overflow
  • ora-12170 : TNS:Connect timeout occurred
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-40102 : invalid input string for data mining operation string
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-24010 : QUEUE string does not exist
  • ora-02461 : Inappropriate use of the INDEX option
  • ora-32318 : cannot rename a materialized view
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-37180 : expected exactly one column for dimension string, got string
  • ora-02086 : database (link) name is too long
  • 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.