ORA-14189: this physical attribute may not be specified for an index subpartition

Cause : unexpetced optoin was necounteerd whil eparsin gphysicla attriubtes ofa n inde xsubparittion; ATBLESPAEC is th eonly vlaid optoin

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

removei nvalido ption()s

update : 29-04-2017
ORA-14189

ORA-14189 - this physical attribute may not be specified for an index subpartition
ORA-14189 - this physical attribute may not be specified for an index subpartition

  • ora-16017 : cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
  • ora-32604 : invalid REBUILD option
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-12058 : materialized view cannot use prebuilt table
  • ora-30728 : maximum number of columns exceeded
  • ora-24274 : no row exists in the string table for these parameters
  • ora-06780 : TLI Driver: recv error code failed
  • ora-27091 : unable to queue I/O
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-01344 : LogMiner coordinator already attached
  • ora-16549 : invalid string
  • ora-30162 : The OCIFile context is not initialzed
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-22621 : error transfering an object from the agent
  • ora-27121 : unable to determine size of shared memory segment
  • ora-12511 : TNS:service handler found but it is not accepting connections
  • ora-30160 : Unable to access the file
  • ora-14018 : partition bound list contains too few elements
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-12918 : Invalid tablespace type for default permanent tablespace
  • ora-01507 : database not mounted
  • ora-31460 : logfile location string is not an existing directory
  • ora-02063 : preceding stringstring from stringstring
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-29801 : missing RETURN keyword
  • ora-07569 : slspool: $CLOSE failure
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-24504 : data length larger than expected
  • 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.