|
-
Find out what object still in block ...
Find the file_id from dba_data_files ...
sql> select file_id from dba_data_files
where file_name = '"/ora/data/blprod/jupiterd_m01.dbf";
then
sql> SELECT SEGMENT_NAME, SEGMENT_TYPE
FROM DBA_EXTENTS
WHERE FILE_ID = #fromabove
AND 72193 BETWEEN block_id AND block_id + blocks;
HTH
Gregg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|