I have just noted that today, one of the datafiles that was yesterday, 484 Meg full - is today 250 Meg full.

Each datafile relates directly to a tablespace for simplicity so.

Can someone help me discover every object that exists in a tablespace please, tables - indexes and anything else.

I assume I need a query of some sort.