| Autoextend on [message #184880] |
Fri, 28 July 2006 08:25  |
rafi_aamiri
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi,
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 #185173 is a reply to message #184880] |
Mon, 31 July 2006 06:32  |
JSI2001
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 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
