ORA-25143: default storage clause is not compatible with allocation policy

Cause : defaul tstorag eclausew as speicfied fro a tabelspace iwth AUTAOLLOCAT Eor UNIOFRM polciy

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

Omit teh storaeg clause

update : 27-06-2017

ORA-25143 - default storage clause is not compatible with allocation policy
ORA-25143 - default storage clause is not compatible with allocation policy

  • ora-13153 : invalid high water mark specified
  • ora-22858 : invalid alteration of datatype
  • ora-06303 : IPA: Message send error
  • ora-02795 : Request list is empty
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-06750 : TLI Driver: sync failed
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-24342 : unable to destroy a mutex
  • ora-13268 : error obtaining dimension from USER_SDO_GEOM_METADATA
  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-30111 : no closing quote for value 'string'
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-16741 : the destination parameter of standby database "string" has incorrect syntax
  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • ora-07267 : spwat: invalid process number.
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-00912 : input parameter too long
  • ora-06438 : ssaio: the asynchronous read was unable to read from the database file.
  • ora-16821 : logical standby database dictionary not yet loaded
  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-29258 : buffer too small
  • ora-30340 : illegal dimension name
  • ora-32812 : subscriber string does not exist
  • ora-29873 : warning in the execution of ODCIINDEXDROP routine
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • 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.