How do you resize a data file and tablespace?

@ : Home > > Interview Room

- Before Oracle 7.2, you can’t resize a datafile.
- The solution was to delete the tablespace, recreating it with different sized datafiles.
- After 7.2 you can resize a datafile by using ALTER DATABASE DATAFILE <file_name> RESIZE;
- Resizing Table space includes the creation of new data file or resizing existing data file.
- ALTER TABLESPACE <tablespacename> ADD DATAFILE ‘<datafile name> ‘ size G; creates a new datafile

Alert me