Home » RDBMS Server » Server Administration » create table space (10g)
create table space [message #354542] Mon, 20 October 2008 04:19 Go to next message
just.rahul
Messages: 9
Registered: November 2007
Junior Member
hi,

how to create table space with autoext on and min and max size
Re: create table space [message #354544 is a reply to message #354542] Mon, 20 October 2008 04:29 Go to previous messageGo to next message
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 Go to previous message
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:
  


Current Time: Thu Dec 08 12:47:49 CST 2016

Total time taken to generate the page: 0.09524 seconds