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 : 24-05-2017
ORA-31116

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

  • ora-14043 : only one partition may be added
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-12075 : invalid object or field
  • ora-27010 : skgfwrt: write to file failed
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-14517 : subpartition of index 'string.string' is in unusable state
  • ora-29956 : warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-01539 : tablespace 'string' is not online
  • ora-13515 : Error encountered during Database Usage Statistics capture
  • ora-09805 : conversion of category number to string failed.
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-31425 : subscription does not exist
  • ora-24376 : cannot register/get user callback for non-environment handle
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-26015 : Array column string in table string is not supported by direct path
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-13910 : Parameter string cannot be NULL.
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-00609 : could not attach to incoming connection
  • ora-13524 : error encountered while retrieving baseline information
  • ora-19644 : datafile string: incremental-start SCN is prior to resetlogs SCN string
  • 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.