I am trying to drop some data files to free up disk space. In order to do that we first need to know how to identify the data file that has 0 extents allocated. I am stuck at the arriving at the query that will show me the datafile that has no extents allocated. Any help is greatly appreciated.

ரூபன் இம்மானுவேல்
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.