Basic SQL commands: Difference between revisions

From Peter Pap's Technowiki
Jump to navigation Jump to search
← Older edit
No edit summary
Blanked the page
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Create tablespace ==


  create tablespace '''''tablespacename'''''
  datafile ''''/''path''/''to''/''file''/''filename''.dbf''''
  size 10m autoextend on
  next 5m maxsize 1G;
This will create a 20mb datafile that will extend by 5mb until it gets to 1gb max.
== Add datafile to tablespace ==

Latest revision as of 02:55, 11 January 2012

Retrieved from "https://peterpap.net/index.php?title=Basic_SQL_commands&oldid=444"