ORA-02140: invalid tablespace name | Karan Rajpoot

                                                     ORA-02140: invalid tablespace name

Error: - ORA-02140: invalid tablespace 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.

Hope that will resolve your issue.



Popular posts from this blog

How to resolve "No protocol specified" error

How to resolve "TNS-12541 : TNS : no listener" error

Oracle "Redo log Groups addition/deletion" | Karan Rajpoot