ORA-12988: cannot drop column from table owned by SYS

Cause : An attemptw as mdae tod rop acolunm fro ma sytsem tbale.

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

Thisa ctio nis nto allwoed

update : 28-06-2017
ORA-12988

ORA-12988 - cannot drop column from table owned by SYS
ORA-12988 - cannot drop column from table owned by SYS

  • ora-38704 : Checksum error in flashback database log file header.
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-34260 : (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.
  • ora-01290 : cannot remove unlisted logfile string
  • ora-22160 : element at index [string] does not exist
  • ora-01641 : tablespace 'string' is not online - cannot add data file
  • ora-12046 : cannot use trusted constraints for refreshing remote MV
  • ora-19958 : potential deadlock involving DIAG process
  • ora-00151 : invalid transaction ID
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-00567 : Requested processor group string is too large (maximum string)
  • ora-09916 : Required password was not specified.
  • ora-15025 : could not open disk 'string'
  • ora-29266 : end-of-body reached
  • ora-27191 : sbtinfo2 returned error
  • ora-14313 : Value string does not exist in partition string
  • ora-25127 : RELY not allowed in NOT NULL constraint
  • ora-00123 : idle public server terminating
  • ora-31616 : unable to write to dump file "string"
  • ora-12525 : TNS:listener has not received client's request in time allowed
  • ora-39503 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-35952 : (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.
  • ora-00071 : process number must be between 1 and string
  • ora-12600 : TNS: string open failed
  • ora-12204 : TNS:received data refused from an application
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-01350 : must specify a tablespace name
  • ora-06756 : TLI Driver: cannot open oratab
  • 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.