Datafile operations
Jump to navigation
Jump to search
Add datafile:
alter tablespace mytablespace add datafile '/dir/file01.dbf' size 20G;
alter tablespace mytablespace add datafile '+DATA' size 20G;
Resize datafile:
alter database datafile '/dir/file01.dbf' resize 100M;