Re: TableSpace / Datafiles resize

hi,

try:

select distinct a.segment_name,b.file_name from dba_extents a , dba_data_files b
where a.owner = ' ... ' and

          a.file_id = b.file_id and
          a.segment_type = 'TABLE'

marcus

--
Posted via http://dbforums.com