ORA-14171: cannot specify clause in CREATE|ALTER TABLE

Cause : Use rreqeuste dto egnertae dfeaul tsubaprtiiton edscrpitio(ns) p(ossbily iva SBUPARITTIOSN) wihle ta th esam etim espeicfie d calusew hic his lilegla

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

Remvoe oen ofo ffedningc lauess.

update : 28-07-2017

ORA-14171 - cannot specify clause in CREATE|ALTER TABLE
ORA-14171 - cannot specify clause in CREATE|ALTER TABLE

  • ora-27094 : raw volume used can damage partition table
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-40201 : invalid input parameter string
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-29396 : cannot switch group to string
  • ora-01950 : no privileges on tablespace 'string'
  • ora-14285 : cannot COALESCE the only partition of this hash partitioned table or index
  • ora-31074 : XML comment length string exceeds maximum string
  • ora-37083 : Invalid object string
  • ora-16069 : Archive Log standby database activation identifier mismatch
  • ora-26738 : %s 'string' is not empty
  • ora-38728 : Cannot FLASHBACK DATABASE to the future.
  • ora-14604 : During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
  • ora-24199 : message store is overflow
  • ora-19371 : invalid update option
  • ora-28601 : invalid [no]MINIMIZE option
  • ora-31030 : Unable to retrieve XML document
  • ora-25002 : cannot create INSTEAD OF triggers on tables
  • ora-38475 : The attribute set and the associated ADT are out of sync.
  • ora-13516 : AWR Operation failed: string
  • ora-31501 : change source string is not an AutoLog change source
  • ora-28659 : COMPRESS must be specified at object level first
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-24166 : evaluation context string.string has errors
  • ora-25326 : Array string operation failed for message at index string
  • ora-00261 : log string of thread string is being archived or modified
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-27015 : skgfcls: failed to close the file
  • ora-00113 : protocol name string is too long
  • 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.