Basic SQL commands - Revision history

Ppapa: Blanked the page

2012-01-11T02:55:48Z

Blanked the page

Ppapa at 02:54, 11 January 2012

2012-01-11T02:54:45Z

Ppapa: /* Add datafile to tablespace */

2012-01-11T02:53:36Z

‎Add datafile to tablespace

Ppapa at 02:52, 11 January 2012

2012-01-11T02:52:37Z

Ppapa at 02:51, 11 January 2012

2012-01-11T02:51:51Z

Ppapa at 02:51, 11 January 2012

2012-01-11T02:51:39Z

Ppapa at 02:51, 11 January 2012

2012-01-11T02:51:20Z

Ppapa: /* Create tablespace */

2012-01-11T02:50:53Z

‎Create tablespace

Ppapa: Created page with " == Create tablespace == create tablespace gkdata datafile '/path/to/file/filename.dbf' size 10m autoextend on next 5m maxsize 1G;"

2012-01-11T02:49:23Z

Created page with " == Create tablespace == create tablespace gkdata datafile '/path/to/file/filename.dbf' size 10m autoextend on next 5m maxsize 1G;"

New page

== Create tablespace ==

create tablespace gkdata
datafile '/path/to/file/filename.dbf'
size 10m autoextend on
next 5m maxsize 1G;

← Older revision		Revision as of 02:55, 11 January 2012
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''/''file''/''filename''.dbf''''~~
−	~~size 10m autoextend on~~
−	~~next 5m maxsize 1G;~~

@@ Line 10: / Line 10: @@
 == Add datafile to tablespace ==
-   alter tablespace tablespacename
+   alter tablespace '''''tablespacename'''''
-    add datafile '/path/to/datafile/datafile
+    add datafile ''''/''path''/''to''/''file''/''filename''.dbf''''

← Older revision		Revision as of 02:53, 11 January 2012
Line 9:		Line 9:

	== Add datafile to tablespace ==		== Add datafile to tablespace ==
		+
		+	alter tablespace tablespacename
		+	add datafile '/path/to/datafile/datafile

← Older revision		Revision as of 02:52, 11 January 2012
Line 6:		Line 6:
	next 5m maxsize 1G;		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 ==		== Add datafile to tablespace ==

@@ Line 1: / Line 1: @@
 == Create tablespace ==
-   create tablespace ''tablespacename''
+   create tablespace '''''tablespacename'''''
     datafile ''''/''path''/''to''/''file''/''filename''.dbf''''
     size 10m autoextend on

@@ Line 2: / Line 2: @@
 == Create tablespace ==
-   create tablespace gkdata
+   create tablespace ''tablespacename''
-    datafile '/path/to/file/filename.dbf'
+    datafile '''/path/to/file/filename.dbf'''
     size 10m autoextend on
     next 5m maxsize 1G;