What is the view name where i can get the space in MB for tables or views?

Select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name
  • Interview Candidate
  • 1
  • 1707

Showing Answers 1 - 1 of 1 Answers

satish penugonda

  • Jul 7th, 2006
 

and adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information for views

  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