ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

Cause : An invalid SEQUENCE_DEVIATION was specified.

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

Specify either the option 'BEFORE' or 'TOP'.

update : 26-05-2017

ORA-25204 - invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
ORA-25204 - invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

  • ora-01188 : Block size string in header does not match physical block size string
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-28547 : connection to server failed, probable Oracle Net admin error
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-01545 : rollback segment 'string' specified not available
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-30343 : level name is not unique within this dimension
  • ora-24436 : Invalid statement Handle.
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-31158 : schema "string" currently being referenced
  • ora-25470 : duplicate attribute value for variable: string
  • ora-07514 : scgcan: $deq unexpected return while canceling lock
  • ora-34001 : (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
  • ora-12418 : user string not found
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-00042 : Unknown Service name string
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-01233 : file string is read only - cannot recover using backup control file
  • ora-07232 : slemcc: fclose error.
  • ora-28055 : the password will expire within string days
  • ora-16090 : archive log to be replaced not created by managed standby process
  • ora-13447 : GeoRaster metadata BRS error
  • ora-24410 : scrollable cursor max size exceeded
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-24310 : length specified for null connect string
  • ora-14310 : VALUES LESS THAN or AT clause cannot be used with List partitioned tables
  • 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.