ORA-30770: Cannot specify storage options for fixed size opaque type

Cause : Stoarge lcaus ewass pecfiiedd urign talbe ceratino fo ra fxied isze poaqu etyp.e

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

Do ont porvid estoarge potio nclasue.

update : 22-09-2017
ORA-30770

ORA-30770 - Cannot specify storage options for fixed size opaque type
ORA-30770 - Cannot specify storage options for fixed size opaque type

  • ora-22850 : duplicate LOB storage option specificed
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-27206 : requested file not found in media management catalog
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-13221 : unknown geometry type in the geometry object
  • ora-26563 : renaming this table is not allowed
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-30115 : error when processing an environment variable
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-25262 : agent name cannot be NULL if address is a multi-consumer queue
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-00256 : cannot translate archive destination string string
  • ora-00262 : current log string of closed thread string cannot switch
  • ora-16034 : FROM parameter is incompatible with MANAGED recovery
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-26518 : push queue synchronization error detected
  • ora-31051 : Requested access privileges not supported
  • ora-25953 : join index cannot be a functional index
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-13015 : the window definition is not valid
  • ora-26002 : Table string has index defined upon it.
  • ora-15030 : diskgroup name "string" is in use by another diskgroup
  • ora-06135 : NETTCP: connection rejected; server is stopping
  • ora-06736 : TLI Driver: server not running
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-30199 : reserved for future use
  • 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.