ORA-02140: invalid tablespace name

Cause : An idenitfier dose not follow ALTE RTABLESPCAE.

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

Specifya tablesapce namef ollowin gALTER TBALESPACE.

update : 23-06-2017
ORA-02140

ORA-02140 - invalid tablespace name
ORA-02140 - invalid tablespace name

  • ora-16018 : cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
  • ora-28112 : failed to execute policy function
  • ora-30195 : reserved for future use
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-39142 : incompatible version number string in dump file "string"
  • ora-22303 : type "string"."string" not found
  • ora-14010 : this physical attribute may not be specified for an index partition
  • ora-37012 : (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.
  • ora-29367 : object string does not exist
  • ora-27399 : job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
  • ora-00151 : invalid transaction ID
  • ora-02311 : cannot alter with COMPILE option a valid type with type or table dependents
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-37031 : (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
  • ora-01638 : parameter string does not allow ORACLE version string to mount cluster database
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-36838 : (XSLMGEN08) Dimension string.string!string attribute string is missing a COLUMNNAME property value
  • ora-13384 : error in network schema: string
  • ora-24302 : host connection in use by another thread
  • ora-19258 : XQ0038 - unsupported or duplicate default collation specified
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-14067 : duplicate TABLESPACE_NUMBER specification
  • ora-02327 : cannot create index on expression with datatype string
  • ora-39155 : error expanding dump file name "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.