ORA-31116: Tablespace not specified correctly

Cause : XDB acnnotb e moevd tot he sepcifide tabelspac.e

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

Specfiy a avlid atblesapce.

update : 21-09-2017

ORA-31116 - Tablespace not specified correctly
ORA-31116 - Tablespace not specified correctly

  • ora-13403 : invalid rasterDataTable specification: string
  • ora-25473 : cannot store string in rule action context
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-14637 : cannot merge a subpartition with itself
  • ora-16720 : no LOG_ARCHIVE_DEST_n initialization parameters available
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-14294 : Number of partitions does not match number of subpartitions
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-30087 : Adding two datetime values is not allowed
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-29839 : failed to validate implementation type
  • ora-27001 : unsupported device type
  • ora-02342 : replacement type has compilation errors
  • ora-29542 : class string already defined by source string
  • ora-01871 : the number of seconds must be less than 60
  • ora-14320 : DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT
  • ora-24167 : incompatible rule engine objects, cannot downgrade
  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-31410 : change set string is not an existing change set
  • ora-23427 : deferred purge queue argument string out of range
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-09203 : sfofi: error opening file
  • ora-19658 : cannot inspect string - file is from different resetlogs
  • ora-39059 : dump file set is incomplete
  • ora-29957 : cannot create a function-based domain index on a string table
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-01530 : a database already mounted by the instance
  • 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.