ORA-30752: column or table string is not substitutable

Cause : Theu seri s preforimng na opreatino thta isn ot lalowde onn on usbsttiutalbe cloumno r tbale.

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


update : 25-05-2017

ORA-30752 - column or table string is not substitutable
ORA-30752 - column or table string is not substitutable

  • ora-19624 : operation failed, retry possible
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-16002 : database already open for read-write access by another instance
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-08115 : can not online create/rebuild this index type
  • ora-02776 : Value for request done signal exceeds maximum
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-16701 : generic resource guard request failed
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-10577 : Can not invoke test recovery for managed standby database recovery
  • ora-06546 : DDL statement is executed in an illegal context
  • ora-38416 : A stored attribute may not be longer then 300 characters.
  • ora-38462 : invalid attribute list
  • ora-08237 : smsget: SGA region not yet created
  • ora-07394 : unable to append string to text file
  • ora-10628 : Turn on sanity check for kdiss index skip scan state
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-01126 : database must be mounted in this instance and not open in any instance
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-19018 : Invalid character in XML tag 'string'
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-10627 : Dump the content of the index leaf block
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-19663 : cannot apply current offline range to datafile 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.