introduction

CREATE object_type object_name

create options

STORAGE (storage parameters)

create tablespace

create tablespace ar DATAFILE 'c:\orant\data\oractp_allk.dbf' SIZE 500M

AUTOEXTEND ON NEXT 200M MAXSIZE 1024M

either of the following; anything below here is the default for objects created in the tablespace

DEFAULT STORAGE (INITIAL 10M NEXT 1M PCTINCREASE 10)
default pctincrease is 50%

LOCAL UNIFORM SIZE 2M

PERMANENT

ONLINE

LOGGING;

first size specification is for the database, second size specification is the default for all objects created in the tablespace.

[DEFAULT] STORAGE (INITIAL x [K|M] NEXT x [K|M] MINEXTENTS x MAXEXTENTS x PCTINCREASE x FREELISTS x FREELIST GROUPS x OPTIMAL x [K|M]

freelist groups

applies to parallel server instances only; creates a freelist group for each instance accessing a table concurrently

optimal

applies only to rollback segments; specifies the size the rollback segment will shrink back to once it has grown past its OPTIMAL setting

create database

create database ortest1

controlfile reuse

datafile '/home/u01/data/ortest1/t1.dbf' auto_extend_clause

logfile '/home/u01/redo/ortest1/t1log.f' siZE 10M

'/home/u01/redo/ortest1/t1log2.f' siZE 10M

maxinstances 1

maxdatafiles 1022

maxlogfiles 20
for the max number of redo log files in each log group

maxlogmembers 3
for the number of log groups

[ARCHIVELOG| NOARCHIVELOG]

[CHARSET charset]

maxarchlogs 0

extent_management_clause

autoextend_clause

size 32M

autoextend on|off

next n K|M

maxsize n

UNLIMITED K|M