Hi..

I reframe the question again..

I need to know objects in a perticular datafile. If I have a tablespace with 2 datafiles having a sufficient space empty. Then I would like to drop one of the datafile. For that I need to know if the datafile is empty or not...

I can findout the objects in tablespace.. But I like to see the objects in datafiles of that tablespace.

Thanks

Sameer


<----------------------- old post --------------------->

Hello,

How do I find which database objects are stored in a datafile?

Thanks

Sameer



[Edited by Sameer on 10-15-2001 at 04:45 AM]