OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » create table space (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create table space [message #354542]

Mon, 20 October 2008 04:19

just.rahul
Messages: 9
Registered: November 2007

Junior Member

hi,

how to create table space with autoext on and min and max size

Report message to a moderator

Re: create table space [message #354544 is a reply to message #354542]

Mon, 20 October 2008 04:29

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

First search on google.....
Anyway find the test example.

create tablespace ts_something
  logging
  datafile '/dbf1/ts_sth.dbf' 
  size 32m 
  autoextend on 
  next 32m maxsize 2048m
  extent management local;

Thanks,

[Updated on: Mon, 20 October 2008 04:31]

Report message to a moderator

Re: create table space [message #354545 is a reply to message #354542]

Mon, 20 October 2008 04:32

ora110
Messages: 42
Registered: September 2007
Location: China

Member

create tablespace tbs_name datafile ' ' size xxM autoextend on maxsize xxxM;

[Updated on: Mon, 20 October 2008 04:50]

Report message to a moderator

Previous Topic:	what are steps to change database name on oracle 9i on linux
Next Topic:	Sys user can login with as sysdba privilege?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:11:02 CDT 2024