Basic SQL commands

From Peter Pap's Technowiki
Revision as of 02:53, 11 January 2012 by Ppapa (talk | contribs) (→‎Add datafile to tablespace)

Jump to: navigation, search

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
Retrieved from "https://peterpap.net/index.php?title=Basic_SQL_commands&oldid=442"