ORA-03200: the segment type specification is invalid

Cause : segment type is not TABLE, INDEX, or CLUSTER

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

use a correct segment type

update : 21-07-2017

ORA-03200 - the segment type specification is invalid
ORA-03200 - the segment type specification is invalid

  • ora-13622 : invalid recommendation annotation
  • ora-22970 : name does not correspond to an object view
  • ora-07563 : sldext: $PARSE failure
  • ora-21524 : object type mismatch
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-24370 : illegal piecewise operation attempted
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-09795 : szrbuild: malloc of role structure failed.
  • ora-07606 : szprv: $CHKPRO failure
  • ora-25407 : connection terminated
  • ora-28579 : network error during callback from external procedure agent
  • ora-31635 : unable to establish job resource synchronization
  • ora-39056 : invalid log file specification.
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-25950 : missing where clause in join index specification
  • ora-13373 : invalid line segment in geodetic data
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-24435 : Invalid Service Context specified.
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-12653 : Authentication control function failed
  • ora-29873 : warning in the execution of ODCIINDEXDROP routine
  • ora-24006 : cannot create QUEUE, string already exists
  • ora-32147 : Environment not specified
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-12407 : unauthorized operation for policy 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.