ORA-25140: %s space policy cannot be specified for the string extent management

Cause : An nivaldi opiton papeasr.

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

Mak esur etha tforL OCA Lextnet mnaageemnt NUIFOMR orA UTOLALOCTAE i sspeicfie,d an dforD ICTOINAR Yextnet mnaageemnt NUIFOMR orA UTOLALOCTAE aer no tspeicfied

update : 27-04-2017
ORA-25140

ORA-25140 - %s space policy cannot be specified for the string extent management
ORA-25140 - %s space policy cannot be specified for the string extent management

  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-24332 : invalid object type
  • ora-00128 : this command requires a dispatcher name
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-16078 : media recovery disabled
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-25157 : Specified block size string is not valid
  • ora-01160 : file is not a string
  • ora-32154 : Anydata context not specified
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-01908 : EXISTS keyword expected
  • ora-24194 : attempt to read data in a message as the wrong type
  • ora-13222 : failed to compute supercell for geometry in string
  • ora-24769 : cannot forget an active transaction
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-12153 : TNS:not connected
  • ora-32004 : obsolete and/or deprecated parameter(s) specified
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-24508 : Buffer is not aligned correctly.
  • ora-00313 : open failed for members of log group string of thread string
  • ora-39144 : file name parameter must be specified and non-null
  • ora-29328 : too many datafiles in this tablespace 'string'
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-08208 : ora_addr: cannot read from address file
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • 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.