How do you see specific table space is offline or online ?

Questions by KISHOREDB

Showing Answers 1 - 12 of 12 Answers

sahil

  • Dec 8th, 2011
 

Code
  1. SELECT tablespace_name, STATUS FROM dba_tablespaces;

  Was this answer useful?  Yes

anil kumar

  • Dec 13th, 2011
 

select tablespace_name,status from dba_tablespaces;

  Was this answer useful?  Yes

Arunkumar

  • Dec 28th, 2011
 

Code
  1. SELECT tablespace_name,status FROM dba_tablespaces;

  Was this answer useful?  Yes

Neeraj Kumar Singh

  • Feb 17th, 2012
 

Code
  1. SELECT TABLESPACE_NAME, ONLINE_STATUS FROM DBA_DATA_FILES;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions