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 : 30-04-2017

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-10658 : Lob column to be shrunk is marked unused
  • ora-19604 : conversation file naming phase is over
  • ora-16201 : Skip procedure requested to apply statement
  • ora-27510 : IPC error waiting for a request to complete
  • ora-31444 : parameter error while acquiring lock on string
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-32631 : illegal use of objects in MODEL
  • ora-36637 : (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-22290 : operation would exceed the maximum number of opened files or LOBs
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-02215 : duplicate tablespace name clause
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-12495 : cannot disable an enabled level, category, or release category
  • ora-28661 : Object already has COMPRESS clause specified
  • ora-15050 : disk "string" contains string error(s)
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-31640 : unable to open dump file "string" for read
  • ora-32840 : property name cannot be NULL
  • ora-28359 : invalid certificate identifier
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-07393 : unable to delete text file
  • ora-15152 : cluster in rolling upgrade
  • ora-01622 : thread number must be specified - default not specific
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-19625 : error identifying file string
  • ora-25011 : cannot create trigger on internal AQ table
  • 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.