How to Find Database Object and it’s Corresponding Datafiles
October 11, 2017
Database Scripts, Scripts
![How to Find Database Object and it’s Corresponding Datafiles](https://syedsaadali.com/wp-content/uploads/2023/05/SyedSaadAli_ACE_linkedin-e1685600570483.png)
How to Find Database Object and it’s Corresponding Datafiles
SELECT DISTINCT t.ts#,
t.name AS Tablespace_name,
d.name AS DATAFILE,
s.owner,
s.segment_name,
s.segment_type,
s.bytes / 1024 / 1024 AS “MB”
FROM v$tablespace t,
v$datafile d,
dba_segments s
WHERE t.ts# = d.ts#
AND t.name = s.tablespace_name
AND s.owner = ‘APPS’;
Related Posts