ORA-12996: cannot drop system-generated virtual column

Cause : An attemptw as mdae tod rop avirtaul coulmn gneeratde by hte sytsem.

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


update : 24-07-2017

ORA-12996 - cannot drop system-generated virtual column
ORA-12996 - cannot drop system-generated virtual column

  • ora-26764 : invalid parameter "string" for local capture "string"
  • ora-27084 : unable to get/set file status flags
  • ora-16661 : the standby database needs to be reinstated
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-19023 : The first argument to UPDATEXML operator has to be an XMLTYPE
  • ora-00274 : illegal recovery option string
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-00001 : unique constraint (string.string) violated
  • ora-30001 : trim set should have only one character
  • ora-28338 : cannot encrypt indexed column(s) with salt
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-07235 : slemcw: fwrite error.
  • ora-16729 : validation of value for property string found string error
  • ora-01643 : system tablespace can not be made read only
  • ora-27457 : argument string of job "string.string" has no value
  • ora-13011 : value is out of range
  • ora-01694 : max # extents (string) reached in lob segment string.string partition string
  • ora-25206 : enqueue failed, enqueue to exception queue string.string not permitted
  • ora-09756 : osnpns: no port in the name server.
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-12409 : policy startup failure for string policy
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • ora-13860 : Invalid service name
  • ora-22056 : value [string] is divided by zero
  • 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.