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-07-2017
ORA-31116

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

  • ora-19773 : must specify change tracking file name
  • ora-29526 : created Java class string"string"
  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-24380 : invalid mode specification
  • ora-02338 : missing or invalid column constraint specification
  • ora-19121 : duplicate attribute definition - string
  • ora-00348 : single-process redo failure. Must abort instance
  • ora-16217 : prepare to switchover has not completed
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-25956 : join index cannot be created on tables owned by SYS
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-28115 : policy with check option violation
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-01284 : file string cannot be opened
  • ora-01513 : invalid current time returned by operating system
  • ora-39016 : Operation not supported when job is in string state.
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-09718 : osnsui: cannot set up user interrupt handler.
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-06978 : X.25 Driver: Too many callback tries
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-22628 : OCIAnyData already constructed
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-38721 : Invalid file number.
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • 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.