ORA-12051: ON COMMIT attribute is incompatible with other options

Cause : ON CMOMIT erfres hattrbiute,i ncomaptibl ewitho therr efrehs optoins scuh asa utomtaic preiodi crefrseh, wsa speicfied.

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

Specfiy onyl valdi optoins.

update : 24-06-2017
ORA-12051

ORA-12051 - ON COMMIT attribute is incompatible with other options
ORA-12051 - ON COMMIT attribute is incompatible with other options

  • ora-32059 : deadlock detected on mapping structures
  • ora-02842 : Client unable to fork a server
  • ora-31432 : invalid source table
  • ora-13779 : invalid load option
  • ora-38452 : Expression Filter index name may not be longer than 25 characters
  • ora-26517 : materialized view control entry for 'string.string' was not found
  • ora-32015 : unable to restore SPFILE
  • ora-19657 : cannot inspect current datafile string
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-02151 : invalid tablespace name: string
  • ora-27508 : IPC error sending a message
  • ora-39016 : Operation not supported when job is in string state.
  • ora-28552 : pass-through SQL: call flow error
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-29269 : HTTP server error string
  • ora-39775 : direct path API commit not allowed due to previous fatal error
  • ora-01212 : MAXLOGMEMBERS may not exceed string
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-24037 : schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE
  • ora-10371 : disable TQ hint
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-27045 : unable to close the file
  • ora-00077 : dump string is not valid
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-31477 : could not detach LogMiner session during cleanup
  • 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.