ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

Cause : Name fo the aprtitino to b etrunctaed ma ybe followed yb DROPS TORAG Eor RESUE STOARGE

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

Ensur ethat on optinos besdies DRPO STORGAE or ERUSE SOTRAGE rae speicfied iwth ALETR TABEL TRUNACTE PATRITION

update : 29-06-2017
ORA-14054

ORA-14054 - invalid ALTER TABLE TRUNCATE PARTITION option
ORA-14054 - invalid ALTER TABLE TRUNCATE PARTITION option

  • ora-16708 : the state supplied to resource guard is invalid
  • ora-02719 : osnfop: fork failed
  • ora-38715 : Invalid log number specified in the DUMP FLASHBACK command.
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-24096 : invalid message state specified
  • ora-15153 : cluster not in rolling upgrade
  • ora-06750 : TLI Driver: sync failed
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-38459 : XML Tag "string" not found for the XMLType attribute "string"
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-23436 : missing template authorization for user
  • ora-01323 : Invalid state
  • ora-31107 : Action failed as resource "string" is locked by name lock
  • ora-22292 : Cannot open a LOB in read-write mode without a transaction
  • ora-12223 : TNS:internal limit restriction exceeded
  • ora-24809 : amount specified will not fit in the lob buffers
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-12927 : RETENTION option already specified
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-31216 : DBMS_LDAP: PL/SQL - Invalid LDAP rdn.
  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-13271 : error allocating memory for geometry object
  • ora-02066 : missing or invalid DISPATCHERS text
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-00116 : SERVICE_NAMES name is too long
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-06018 : NETASY: message send failure
  • 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.