Question

Where the table gets storage in oracle?

Answer 1

Connect to the database as usual
Click on the Schema tab
On the Tables link within Database ObjectsEnter the schema name and object name (optional) and click Go
Use the radio button to select the table you want to look at and click onEdit (Don't click on the table name link)Click on the Segments tab (and wait...)You will see the size of the table data and the indexes used.

OK, that technically answered your question. But a better way is:

Logon using SQLPLUSRun the script from Vincent.

I like to save the script as t.sql as a quick reference

COLUMN size_mb FORMAT '999,999,990.0' COLUMN num_rows FORMAT '999,999,990' COLUMN fmt_short FORMAT A24 COLUMN owner FORMAT A16 COLUMN table_name LIKE fmt_short COLUMN tablespace_name LIKE fmt_short SET LINESIZE 200 SET AUTOTRACE OFF COMPUTE SUM OF size_mb ON REPORT BREAK ON REPORT SELECT lower( owner ) AS owner ,lower(table_name) AS table_name ,tablespace_name ,num_rows ,blocks*8/1024 AS size_mb ,pct_free ,compression ,logging FROM all_tables WHERE owner LIKE UPPER('&1') OR owner = USER ORDER BY 1,2; CLEAR COMPUTES CLEAR BREAKS