ORA-34840: (OPCREATE01) The string option must be declared with datatype string.

Cause : An attepmt was mdae to delcare theo ption wtih the worng dataytpe.

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

Declaret he optino with teh correc tdatatyp.e

update : 24-08-2017
ORA-34840

ORA-34840 - (OPCREATE01) The string option must be declared with datatype string.
ORA-34840 - (OPCREATE01) The string option must be declared with datatype string.

  • ora-07584 : spdcr: invalid value for ORA_sid_(proc_)PQL$_item
  • ora-03205 : partition name is required when partitioned type is specified
  • ora-37108 : (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.
  • ora-06780 : TLI Driver: recv error code failed
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-29829 : implementation type does not exist
  • ora-16193 : Primary and standby network encryption mismatch
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-01512 : error renaming log file string - new file string not found
  • ora-27417 : BYWEEKNO clause is only supported when FREQ=YEARLY
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-26095 : unprocessed stream data exists
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-16072 : a minimum of one standby database destination is required
  • ora-12700 : invalid NLS parameter value (string)
  • ora-09211 : sfwfb: error writing to file
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-24147 : rule string.string does not exist
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-26662 : unable to process STREAMS Data Dictonary information for object
  • ora-26712 : remote object is "string"."string"@"string"
  • ora-06533 : Subscript beyond count
  • ora-06544 : PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [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.