Datafile operations

From Tom's notes
Revision as of 15:17, 8 April 2016 by 193.121.160.69 (talk) (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>...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;
Retrieved from "https://www.hacks.be/wiki/index.php?title=Datafile_operations&oldid=37"