Entries categorized as Resize tablespaces and data files
Resize tablespaces and data files
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...