Difference between revisions of "Basic SQL commands"

From Peter Pap's Technowiki
Jump to: navigation, search
(Add datafile to tablespace)
(Blanked the page)
 
(One intermediate revision 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 ==
 
 
  alter tablespace tablespacename
 
  add datafile '/path/to/datafile/datafile
 

Latest revision as of 02:55, 11 January 2012