space used by tables
in a production environment we are short of disk space. we need to know which tables are occupying the high amount of space from all the tablespaces present in the database, so that we can delete some data (if possible ) from those tables. any sql query to do this task in short amount of time.
Thanx in Advance.