is there a better way of writing this SQL

[Shiva]

It works for me :

UPDATE TABLE_DETAILS SET EXTENT = (SELECT EXTENTS FROM DBA_SEGMENTS WHERE
SEGMENT_NAME IN ('FILE$' )) ;

0 rows updated.

Elapsed: 00:00:00.00

Why are you using 2 nested queries for the same purpose ?

Shiva.