UPDATE TABLE_DETAILS SET EXTENTS = (SELECT EXTENTS FROM DBA_SEGMENTS WHERE SEGMENT_NAME IN (SELECT DISTINCT(SEGMENT_NAME) FROM DBA_SEGMNETS WHERE SEGMENT_NAME =NAME ))


I want to populate the table TABLE_DETAILS column extents with the number of extents for DBA segments .Distinct is used as there are more than 1 segment for some tables .


This SQL seems to hang

regards