Removing Data File

[seelan]

Hi all,

Can anyone tell me the way to drop the datafile?

Seelan

[ggnanaraj]

You cannot drop the datafile alone, you have to size it very less (say 6k) if you don't want it to be used.

HTH.

[seelan]

Hi ggnanaraj,
Thanks for ur reply

Seelan

[anandkl]

Hi,
If the datafile already contain data,and if we try to resize it say 6k,it gives an error saying that the datafile contains data more than the specified size,so how do i drop it in this case.

regards
anandkl

[ggnanaraj]

Originally posted by anandkl
If the datafile already contain data,and if we try to resize it say 6k,it gives an error saying that the datafile contains data more than the specified size,so how do i drop it in this case.

1. Identify the objects in that datafile.
2. Export the objects.
3. Resize datafile. (cannot drop datafile)
4. Import the objects.

HTH.

[anandkl]

If the tablespace contains only one datafile,
then we can use

alter database datafile 'file_name' offline drop;

then drop the tablespace.

regards
anandkl