Skip to Main Content
  • Questions
  • Querying DR secondary database in mount mode for Tablespace max total size and available free space

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Foqia.

Asked: November 03, 2015 - 2:49 pm UTC

Last updated: November 04, 2015 - 1:31 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

I am unable to find which v$view should I query to analyze tablespaces max total sizes and available free space in a database which is in mount mode. Could you please help ?

Thanks and regards,
FK

and Connor said...

I dont think you'll be able to do that. The best information you've got (in mount mode) is probably:

v$datafile
v$tablespace

but I dont think you'll be able to glean the information you want from them.



Is this answer out of date? If it is, please let us know via a Comment