www.oraclebd.com Forum Index www.oraclebd.com
Open Oracle discussion Forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Autoextend Tablespace Size Configure

 
Post new topic   Reply to topic    www.oraclebd.com Forum Index -> Problem and Solution
View previous topic :: View next topic  
Author Message
Masud



Joined: 25 Oct 2007
Posts: 1
Location: Bangladesh
PostPosted: Mon Nov 02, 2009 11:40 am    Post subject: Autoextend Tablespace Size Configure Reply with quote
Dear ....

How can I configure autoextend tablespace??

Seems I use

CREATE TABLESPACE TEST
DATAFILE 'TEST.ORA' SIZE 512M AUTOEXTEND ON;

But Now Tablesapcesize 4GB & It cann't be autoextend means autoextend max size may be 4 GB.

So how can I solve this type of Prblm??

Thnx...

Masud Chowdhury
Back to top
View user's profile Send private message Yahoo Messenger
Muhammad Abdul Halim



Joined: 06 Nov 2007
Posts: 9
Location: ERA Infotech Ltd.,28 Topkhana Road,Polton,Dhaka,BD
PostPosted: Mon Jan 25, 2010 1:30 pm    Post subject: Reply with quote
You need to limit with MAXSIZE parameter in the Autoextended datafiles.


Regards
Halim
_________________
The world is filled with willing people...Some willing to work, the rest willing to let them.
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    www.oraclebd.com Forum Index -> Problem and Solution All times are GMT + 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group