Re: How to drop Datafile from Tablespace?

It would be quicker, cheaper and safer to check the file_id of all extents in dba_extents. Don't forget, you could have added an extent which currently contains no rows.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

vganoo_at_hotmail.com wrote in message <79fhjt$b7t$1_at_nnrp1.dejanews.com>...
>Adrian,
>
> What Mark is saying is right. Want to add one more point here. If you do
>not have Enterprise Manager you CAN always find out whether any datafile
>contains data or not. This can be done by finding unique file id from
rowid
>from rows from all tables. rowid format is BLOCK Id.Sequence Number of
the
>row within that block.FILE ID This file id can be compared with the file
id
>from dba_data_files for that particular data file.
>
>Good Luck
>Vivek
>
Received on Fri Feb 05 1999 - 14:44:18 CST