ORA-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.

Cause : Create( )failed hwen tryign to cretae the tsadef fil.e

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

Verify eprmissiosn on $(OARCLE_HOM)E/dbs dierctory.

update : 20-09-2017
ORA-09872

ORA-09872 - TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
ORA-09872 - TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.

  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-03292 : Table to be truncated is part of a cluster
  • ora-29502 : NAMED keyword required in CREATE JAVA RESOURCE
  • ora-13111 : cannot add topo_geometry layer [string] to topology
  • ora-30369 : maximum number of columns is 32
  • ora-27054 : NFS file system where the file is created or resides is not mounted with correct options
  • ora-02752 : osnfsmmap: illegal shared memory address
  • ora-31094 : incompatible SQL type "string" for attribute or element "string"
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-37183 : illegal value string for PARTBY
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-37178 : column string has no values
  • ora-00152 : current session does not match requested session
  • ora-13439 : GeoRaster metadata pyramid maxLevel error
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-03124 : two-task internal error
  • ora-19508 : failed to delete file "string"
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-06306 : IPA: Message write length error
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-14310 : VALUES LESS THAN or AT clause cannot be used with List partitioned tables
  • ora-39706 : schema 'string' not found
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-08429 : raw data has invalid digit in display type data
  • ora-28367 : wallet does not exist
  • 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.