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 : 24-04-2017
ORA-02140

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

  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-01743 : only pure functions can be indexed
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-07622 : smscre: $CREATE failure
  • ora-25294 : Cannot propagate user buffered messages to a database with version lower than 10.2
  • ora-31467 : no column found in the source table
  • ora-28584 : heterogeneous apply internal error
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-38438 : getVarchar not possible due to "string" datatype in the attribute set
  • ora-24265 : Insufficient privileges for SQL profile operation
  • ora-29851 : cannot build a domain index on more than one column
  • ora-16055 : FAL request rejected
  • ora-12623 : TNS:operation is illegal in this state
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-13067 : operator requires both parameters from the same topology
  • ora-10936 : trace name context forever
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-06744 : TLI Driver: listener cannot bind
  • ora-06904 : CMX: no transport address available for remote application
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-02210 : no options specified for ALTER TABLE
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-32103 : error from OCI call
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-27058 : file I/O question parameter is invalid
  • 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.