ORA-15104: conflicting CONTENTS options

Cause : The command specified conflicting or duplicate INCLUDING CONTENTS or EXCLUDING CONTENTS options.

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

Specify only one option.

update : 25-06-2017
ORA-15104

ORA-15104 - conflicting CONTENTS options
ORA-15104 - conflicting CONTENTS options

  • ora-19585 : premature end of volume on piece string
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-15025 : could not open disk 'string'
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-07234 : slemcw: fseek error.
  • ora-13412 : invalid scale parameter
  • ora-07407 : slbtpd: invalid exponent.
  • ora-27468 : "string.string" is locked by another process
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-16655 : specified target standby database invalid
  • ora-16513 : maximum requests exceeded
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-30005 : missing or invalid WAIT interval
  • ora-04070 : invalid trigger name
  • ora-29703 : error occurred in global enqueue service operation
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-32303 : mviews with user-defined types cannot reference multiple master sites
  • ora-38451 : index is in an inconsistent state
  • ora-36202 : (XSAGOP01) 'number' is not a valid aggregation operator.
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-27490 : cannot open disabled window "string.string"
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-07700 : sksarch: interrupt received
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-38441 : System could not derive the list of STORED and INDEXED attributes.
  • ora-01208 : data file is an old version - not accessing current version
  • ora-27081 : unable to close the file
  • 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.