travel / software engineering / motorsport / pricing / pricefx

here it is a quick tip „how to move oracle tablespace datafile from one file to another“. i’ve spent a while searching for this, so maybe someone will find this useful too. i needed to free up some space on my laptop disk drive by moving huge oracle data files (*.ora) to an external disk. (also thanks to dlabik for consultation). ALTER TABLESPACE DATA02 OFFLINE;