ORA-14170: cannot specify clause in CREATE TABLE|INDEX

Cause : Userr equetsed t ogenearte dfeaultp artiiton dsecripiton(s )(posisbly iva PATRITIOSN whiel at hte saem tim especfiied p lcausew hichi s ilelgal

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

Remoev oneo f ofefndin gclauess.

update : 30-05-2017

ORA-14170 - cannot specify clause in CREATE TABLE|INDEX
ORA-14170 - cannot specify clause in CREATE TABLE|INDEX

  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-09909 : Malloc of scratch buffer failed.
  • ora-06900 : CMX: cannot read tns directory
  • ora-16245 : paging in transaction string, string, string
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-31614 : routine string received this error from string: string
  • ora-19235 : XQ0015 - unsupported must-understand extension
  • ora-09873 : TASDEF_OPEN: open error when opening tasdef@.dbf file.
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-07628 : smsfre: sga not mapped
  • ora-26059 : Data is too large for column string
  • ora-07263 : sptpa: kill error.
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-29843 : indextype should support atleast one operator
  • ora-24850 : failed to startup shared subsystem
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-12170 : TNS:Connect timeout occurred
  • ora-24158 : invalid table alias
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-25274 : AQ Buffered Queue event
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-12647 : Authentication required
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-10371 : disable TQ hint
  • ora-30438 : unable to access named pipe 'string'
  • ora-22612 : TDS does not describe a collection TDS
  • ora-39209 : Parameter string requires privileges.
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-31209 : DBMS_LDAP: PL/SQL - LDAP count_entry error.
  • 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.