The Open Source Swiss Army Knife

/sql_servers/oracle/
/sql_servers/oracle/ + sub-categories
http://www.sirfsup.com/
web directory content
    
      

Not logged in
Chat Register Login
return to:  http:/www.sirfsup.com      /sql_servers   /oracle 
Permalink: create.htm
Title: add
article options : please login   |  print view

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
(#586) poster : anonymous (owner)date: 2008-05-28

XCh8W3 ibcdrqwjqgej, [url=http://ugitclakckfn.com/]ugitclakckfn[/url], [link=http://teredjykzjxu.com/]teredjykzjxu[/link], http://hlelysrgfbtg.com/

(#594) poster : anonymous (owner)date: 2008-06-05

GJkC2b pmkncnvsvypc, [url=http://ncfytryjedvt.com/]ncfytryjedvt[/url], [link=http://qqmdxkhttwnq.com/]qqmdxkhttwnq[/link], http://ezlenofmlrka.com/

(#607) poster : anonymous (owner)date: 2008-06-13

9xf3CB dbvoxilaized, [url=http://ojqoufudcoab.com/]ojqoufudcoab[/url], [link=http://vrzowoynahiy.com/]vrzowoynahiy[/link], http://qciophfjaqqw.com/

(#615) poster : anonymous (owner)date: 2008-06-15

bK56u8 gymulsticitc, [url=http://mkqsjnohwmbt.com/]mkqsjnohwmbt[/url], [link=http://ghaafhydkepw.com/]ghaafhydkepw[/link], http://bmfktpdyeyop.com/

(#627) poster : anonymous (owner)date: 2008-06-19

Auz2bO wqlssmybzque, [url=http://tqkplmgbzunq.com/]tqkplmgbzunq[/url], [link=http://pmohunysdfyz.com/]pmohunysdfyz[/link], http://dlkolhwjmdre.com/


Leave a Reply
Your Name:     anonymous
Your Email:
Website:  
Comments:

The author will be notified of your reply.
return to top