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 : 21-07-2017
ORA-02140

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

  • ora-12531 : TNS:cannot allocate memory
  • ora-01186 : file string failed verification tests
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-40251 : no support vectors were found
  • ora-02750 : osnfsmmap: cannot open shared memory file ?/dbs/ftt_.dbf
  • ora-16555 : the Data Guard database is not active
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-30980 : Invalid Input.
  • ora-00285 : TIME not given as a string constant
  • ora-00123 : idle public server terminating
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-02829 : No segment of the proper size is available
  • ora-32016 : parameter "string" cannot be updated in SPFILE
  • ora-31694 : master table string failed to load/unload
  • ora-09749 : pws_look_up: port lookup failure
  • ora-26725 : cannot downgrade apply handlers
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-29830 : operator does not exist
  • ora-13142 : invalid PROXIMITY window definition
  • ora-16807 : unable to change database protection mode
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-29704 : cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
  • ora-32587 : Cannot drop nonexistent string supplemental logging
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-31476 : a change table data column is missing from the source table
  • ora-06122 : NETTCP: setup failure
  • ora-28030 : Server encountered problems accessing LDAP directory service
  • ora-30063 : Internal Event to Test NTP
  • ora-24460 : Native Net Internal Error
  • 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.