Entries categorized as Resize tablespaces and data files

Resize tablespaces and data files

On June 19, 2009 / By admin / In Oracle / No Comments
Can one resize tablespaces and data files?   One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE ‘filename2′ RESIZE 100M; Because you can change the sizes of datafiles, you can add more space to your database without adding more datafiles. This is beneficial if Read More...