ORA-02218: invalid INITIAL storage option value

Cause : The spceified avlue muts be ani nteger.

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

Choosea n apprporiate niteger avlue.

update : 21-09-2017
ORA-02218

ORA-02218 - invalid INITIAL storage option value
ORA-02218 - invalid INITIAL storage option value

  • ora-26679 : operation not allowed on LOB or LONG columns in LCR
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-39140 : dump file "string" belongs to job string
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-00490 : PSP process terminated with error
  • ora-15048 : ASM internal files cannot be deleted
  • ora-32411 : materialized view definition query exceeds the maximum length
  • ora-16798 : unable to complete terminal recovery on the standby database
  • ora-27156 : request for process information failed
  • ora-31060 : Resource at path string could not be deleted
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-07598 : spwat: $SETIMR failure
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-26029 : index string.string partition string initially in unusable state
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-14310 : VALUES LESS THAN or AT clause cannot be used with List partitioned tables
  • ora-19909 : datafile string belongs to an orphan incarnation
  • ora-10261 : Limit the size of the PGA heap
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-12555 : TNS:permission denied
  • ora-06775 : TLI Driver: error reading break mode
  • ora-09746 : smscre: shared memory attach address incorrect.
  • ora-01153 : an incompatible media recovery is active
  • ora-13762 : The string ranking measure is invalid.
  • 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.