Home » RDBMS Server » Server Administration » Autoextend on
Autoextend on [message #184880] Fri, 28 July 2006 08:25 Go to next message
Messages: 34
Registered: September 2005

I created a tablespace with 1024M by specifying autoextend on without specifying the next value for autoextend on.

the script is

create tablespace test datafile 'C:\oracle\oradata\testdb\test.dbf' size 1024M autoextend on MAXSIZE UNLIMITED segment space management auto nologging;

What upon reaching 1024M what would be the next size allocated by oracle to the tablespace "test" here since the next is not specified here.

Thanks in advance.
Re: Autoextend on [message #184934 is a reply to message #184880] Fri, 28 July 2006 15:26 Go to previous messageGo to next message
Messages: 4623
Registered: February 2005
Location: East Coast USA
Senior Member
I think it would be whatever your BLOCKSIZE is, probably 8k, but I wouldn't put money on it.
Re: Autoextend on [message #185173 is a reply to message #184880] Mon, 31 July 2006 06:32 Go to previous message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
I did a very quick test on a 1m dbf which extended by 64k. Didn't test on larger files .... well, 'cos you can do that yourself Smile
Previous Topic: why datafile cant be resized
Next Topic: Problem in Starting Database
Goto Forum:

Current Time: Wed Oct 26 08:30:02 CDT 2016

Total time taken to generate the page: 0.19219 seconds