Difference between revisions of "Datafile operations"
Jump to navigation
Jump to search
(Created page with "Add datafile: <source lang="sql"> alter tablespace mytablespace add datafile '/dir/file01.dbf' size 20G; alter tablespace mytablespace add datafile '+DATA' size 20G; </source>...") |
(No difference)
|
Latest revision as of 15:17, 8 April 2016
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;