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-05-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-00020 : maximum number of processes (string) exceeded
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-13434 : GeoRaster metadata cellRepresentation error
  • ora-12708 : error while loading create database NLS parameter string
  • ora-27433 : cannot alter state of step string for job string.string to string
  • ora-16722 : unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-23368 : name string cannot be null or the empty string
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-25442 : too many column values for table alias: string
  • ora-30379 : query txt not specified
  • ora-27509 : IPC error receiving a message
  • ora-12098 : cannot comment on the materialized view
  • ora-01540 : tablespace 'string' is not offline
  • ora-00153 : internal error in XA library
  • ora-13458 : GeoRaster metadata SRS error
  • ora-13018 : bad distance type
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-23346 : primary key or object ID is undefined for table or materialized view string
  • ora-12690 : Server Authentication failed, login cancelled
  • ora-29319 : datafile string is not correct
  • ora-23325 : parameter type is not string
  • ora-38505 : invalid default value for the attribute
  • ora-32818 : AQ queue string does not exist
  • ora-39219 : directory object name is too long
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-28239 : no key provided
  • ora-01127 : database name 'string' exceeds size limit of string characters
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-12488 : maximum label does not dominate minimum label
  • 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.