0
SQL> select * from v$tablespace where name = 'EXAMPLE';

       TS# NAME                INC BIG FLA ENC     CON_ID
         4 EXAMPLE             YES NO  YES              3

Above query shows that i have a tablespace EXAMPLE

But following query says i have no tablespace with the same name.

SQL> ALTER TABLESPACE EXAMPLE RENAME TO EXAMPLE_NISAR ;
ALTER TABLESPACE EXAMPLE RENAME TO EXAMPLE_NISAR
*
ERROR at line 1:
ORA-00959: tablespace 'EXAMPLE' does not exist

I am logged in as sysdba

migrated from stackoverflow.com Aug 24 '14 at 13:02

This question came from our site for professional and enthusiast programmers.

  • Can you check if select name, dump(name) from v$tablespace where name = upper('example') gives the same name (EXAMPLE) as in your first query? – Yasir Arsanukaev Aug 24 '14 at 12:22
  • No. It,s returning the name of tablespace – emily soto Aug 24 '14 at 12:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.