https://www.hacks.be/wiki/index.php?action=history&feed=atom&title=Datafile_operations Datafile operations - Revision history 2026-04-30T11:41:38Z Revision history for this page on the wiki MediaWiki 1.35.1 https://www.hacks.be/wiki/index.php?title=Datafile_operations&diff=37&oldid=prev 193.121.160.69: 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>..." 2016-04-08T13:17:07Z <p>Created page with &quot;Add datafile: &lt;source lang=&quot;sql&quot;&gt; alter tablespace mytablespace add datafile &#039;/dir/file01.dbf&#039; size 20G; alter tablespace mytablespace add datafile &#039;+DATA&#039; size 20G; &lt;/source&gt;...&quot;</p> <p><b>New page</b></p><div>Add datafile:<br /> &lt;source lang=&quot;sql&quot;&gt;<br /> alter tablespace mytablespace add datafile &#039;/dir/file01.dbf&#039; size 20G;<br /> alter tablespace mytablespace add datafile &#039;+DATA&#039; size 20G;<br /> &lt;/source&gt;<br /> <br /> Resize datafile:<br /> &lt;source lang=&quot;sql&quot;&gt;<br /> alter database datafile &#039;/dir/file01.dbf&#039; resize 100M;<br /> &lt;/source&gt;</div> 193.121.160.69