This content has been marked as final. Show 5 replies
THANK YOU so much to you and to all who trying to help us.
for future visitors
i do the following
SELECT E.SEGMENT_NAME,E. OWNER FROM dba_extents E,dba_data_files D
WHERE D.FILE_ID=E.FILE_ID AND D.FILE_ID=6;
(6 is the file_id of the desired datafile)
and it return no rows.
Thanks & Regards.
Edited by: Maahjoor on 03-Mar-2013 00:13