Let me explain what I am doing
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