ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string

Cause : hT eametirlazidev ei wocsnsisto f aivwea dna c noatniret bael.

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

rDpot ehm tareaiilez divwew tiohtuP ERESVR EATLB Epoitno.

update : 28-04-2017

ORA-26577 - PRESERVE TABLE can not be used when dropping old style materialized view string.string
ORA-26577 - PRESERVE TABLE can not be used when dropping old style materialized view string.string

  • ora-28038 : disallow O2LOGON
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-12661 : Protocol authentication to be used
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-04075 : invalid trigger action
  • ora-37010 : (XSACQUIRE_DIFFAW) When using the CONSISTENT WITH clause, all objects must come from the same analytic workspace.
  • ora-29275 : partial multibyte character
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-07626 : smsget: sga already mapped
  • ora-39761 : stream reset required before loading this stream again
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-13144 : target table string not found
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-37178 : column string has no values
  • ora-27141 : invalid process ID
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-23609 : unable to find directory object for directory string
  • ora-12950 : SYSTEM tablespace specified as default permanent tablespace
  • ora-19667 : cannot do incremental restore of datafile string
  • ora-02708 : osnrntab: connect to host failed, unknown ORACLE_SID
  • ora-08185 : Flashback not supported for user SYS
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-31154 : invalid XML document
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • 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.