is there a better way of writing this SQL

[puneet]

create table Table_details (Name varchar2(81), num_Rows Number(10), extents number(10))

insert into Table_details (Name ,num_Rows) select DISTINCT(table_name) ,num_rows from dba_tables

Just want to populate extents column from dba_segments for those particular tables

Thanks !!!


UPDATE TABLE_DETAILS td SET td.EXTENTS = (SELECT EXTENTS FROM DBA_SEGMENTS WHERE
SEGMENT_NAME IN (SELECT DISTINCT(SEGMENT_NAME) FROM DBA_SEGMENTS
WHERE SEGMENT_NAME = td.name));

Has been running for > 5 min for 300 rows . don't expect iot to stop . please let me know for a better SQL