ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

Cause : ALTER TABLE or ALTER INDEX statement attempted to combine MODIFY DEFAULT ATTRIBUTES OF PARTITION with some other operation (e.g. ADD PARTITION or PCTFREE) which is illegal

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

Ensure that MODIFY DEFAULT ATTRIBUTES is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with partitions, default attributes of partitioned tables/indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will

update : 17-08-2017
ORA-14165

ORA-14165 - MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
ORA-14165 - MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

  • ora-25409 : failover happened during the network operation,cannot continue
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-07823 : sspsqr: $QIO failure
  • ora-39115 : %s is not supported over a network link
  • ora-14625 : subpartition contains rows corresponding to values being dropped
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-08451 : invalid specification of DB in picture mask
  • ora-23609 : unable to find directory object for directory string
  • ora-31529 : could not find publication for CDC subscriber view string.string
  • ora-30042 : Cannot offline the undo tablespace
  • ora-01141 : error renaming data file string - new file 'string' not found
  • ora-13414 : invalid pyramid parameter
  • ora-12323 : unable to open database (link name string)
  • ora-02077 : selects of long columns must be from co-located tables
  • ora-30394 : source statement identical to the destination statement
  • ora-19163 : XP0004 - XQuery type mismatch: argument type mismatch: expected - 'string' got - 'string' for function 'string'
  • ora-40306 : wide data not supported for decision tree model create
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-02253 : constraint specification not allowed here
  • ora-37601 : (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-00338 : log string of thread string is more recent than control file
  • ora-31658 : specifying a schema name requires a table name
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-13185 : failed to generate initial HHCODE
  • ora-08342 : sropen: failed to open a redo server connection
  • 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.