ORA-30370: set operators are not supported in this context

Cause : A se topertaor scuh asU NION ,UNIO NALL,I NTERESCT, ro MINSU wase ncoutneredi n anu nsupoprtedc ontetx, suhc as ni a mtaeriailzed ivew dfeinitoin.

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

Re-sepcifyt he epxressoin toa voidt he ues of est opreator.s

update : 27-04-2017
ORA-30370

ORA-30370 - set operators are not supported in this context
ORA-30370 - set operators are not supported in this context

  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-40251 : no support vectors were found
  • ora-14297 : Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-19706 : invalid SCN
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-23428 : job associated instance number string is not valid
  • ora-07582 : spstp: ORA_SID has illegal value
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-29259 : end-of-input reached
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-22612 : TDS does not describe a collection TDS
  • ora-38718 : Invalid thread number specified in the DUMP FLASHBACK command.
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-24181 : The type string does not exist
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-15102 : invalid POWER expression
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-10929 : trace name context forever
  • ora-28362 : master key not found
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-01078 : failure in processing system parameters
  • ora-02793 : Close of asynchronous I/O failed.
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-32330 : invalid operation on online redefinition interim table "string"."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.