Re: Resize Datafile

alter database datafile 'xxxx' resize 999M;

But if your file contains data past 999M, then you can't truncate it (Oracle will return an error - not harmful) . You'll have to compress you data first (that is, export/drop/import).
Also I don;t now about other OS'es bu on VMS only the EOF pointer will be moved. You need to close the file and do a $ SET FILE/TRUNCATE to actually reduce the number of blocks used by the file.

HTH

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"Gaetan Poitras" <poitrasg_at_crcsogema.com> a écrit dans le message de news:
3ebc2be2.0202070625.2fbface4_at_posting.google.com...


> Hello.

> I am looking to find a solution to reduce the size of a datafile. Is

> it possible and how..?

> Thank you