Hi You can use the "alter database datafile '/path/file_name' resize xxxx M;" to make a bigger file ;-) no need to remove the file from the tablespace !
Sathish Tatikonda wrote: >Hi All, > >Is it possible to delete a datafile from a tablespace? What I want to do it to move >the data from one data file to a bigger data file and delete the old file. > >If will be of great help to me if any pointers are provided for the same. > >thanks in advance, >Sathish. > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Home : +45 3874 5696 Miracle A/S Kratvej 2 2760 M�l�v http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */
smime.p7s
Description: application/pkcs7-signature
