- Get link
- X
- Other Apps
- Get link
- X
- Other Apps
SELECT * FROM ( SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, partition_name, BLOCK_ID FROM DBA_EXTENTS WHERE FILE_ID = ( SELECT FILE_ID FROM DBA_DATA_FILES WHERE FILE_NAME = '<datafile_name>' ) ORDER BY BLOCK_ID DESC ) WHERE ROWNUM <= 7 --last 7 rows ; |
Comments
Post a Comment