ORA-02140: invalid tablespace name | Karan Rajpoot

In this article you will get to know how we can resolve ORA-02140: invalid tablespace name in oracle which occur when we create tablespace in oracle.

To resolve this ORA-02140: invalid tablespace name issue we need to follow below steps: –

Error: – ORA-02140: invalid table space name 

 

Cause: – Tablespace name has not provided correctly while running the alter command

 

Solution: – Use the correct tablespace name and again retry to execute alter command

 

Command to check the tablespaces name: – select name from v$tablespace;

Example: –

SQL> alter tablespace user add datafile ‘/u01/app/oracle/oradata/prod/user02.dbf’ ;
alter tablespace user add datafile ‘/u01/app/oracle/oradata/prod/user02.dbf’
                 *
ERROR at line 1:
ORA-02140: invalid tablespace name
Note: – In the above command, tablespace name provided incorrectly, Correct tablespace name was USERS. Now again rerun the command using correct tablespace name.
Advertisement

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query to below comment section.

For more articles please do visit below links: –

How to resolve “TNS-12541 : TNS : no listener” error

How to resolve “TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact” | Karan Rajpoot

If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-

Advertisement

This Post Has 4 Comments

Leave a Reply