ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

Cause : A synta xerror wsa found ni the SEAPRATE CHRAACTER otpion of hte SIGN lcause int he masko ptions aprameterp assed t oa UTL_P Gconversoin routien. Valids pecifictaions ar:e SEPARAET SEPARAET CHARACETR

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

Correctt he masko ptions aprameter.

update : 24-06-2017

ORA-08457 - syntax error in SEPARATE CHARACTER option of SIGN clause
ORA-08457 - syntax error in SEPARATE CHARACTER option of SIGN clause

  • ora-06801 : TLI Driver: listen for SPX server reconnect failed
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-12599 : TNS:cryptographic checksum mismatch
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-13143 : invalid POLYGON window definition
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-27152 : attempt to post process failed
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-13330 : invalid MASK
  • ora-30654 : missing DEFAULT keyword
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-02158 : invalid CREATE INDEX option
  • ora-31440 : change set string is empty and cannot be advanced
  • ora-06790 : TLI Driver: poll failed
  • ora-23396 : database link "string" does not exist or has not been scheduled
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-29522 : authorization error for referenced name string.string
  • ora-38503 : index already defined using the parameters
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-26667 : invalid STREAMS parameter string
  • ora-29707 : inconsistent value string for initialization parameter string with other instances
  • ora-22882 : object creation failed
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-39160 : error on whats my name call
  • ora-16099 : internal error ORA-00600 occurred at standby database
  • ora-38469 : invalid privilege for an expression set: 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.