| how autoextend works [message #281312] |
Fri, 16 November 2007 06:53  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I created a datafile with 700mb size and autoextend on.
I imported some empty tables into it.
When i checked my disk size,it was 99% full and the size of the file became 2000mb.This means the datafile got autoextended as the tables were imported.BUt the tables were empty and i guess the autoextend option works when there is no space left in the datafile for the data but there was no data in the tables.
Any lights??
|
|
|
|
|
|
|
|
| Re: how autoextend works [message #281343 is a reply to message #281312] |
Fri, 16 November 2007 08:17  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
No delete took place.
The tables were only created and no inserting was done.but they were created in system tablespace.I exported the empty tables from system and imported them into users schema.
but the datafile was autoextended to 2000mb from 700mb.
|
|
|
|
|
|
| Re: how autoextend works [message #281346 is a reply to message #281312] |
Fri, 16 November 2007 08:26 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
When a table gets created in any tablespace,its initial,minextent,maxextent,pctfree etc are set to default unless specified in the create table statement.
The initial extent values of system and users tablespace vary.
|
|
|
|
|
|
| Re: how autoextend works [message #281354 is a reply to message #281312] |
Fri, 16 November 2007 08:43 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
So there happens a mismatch between intial,next,min and max extents and the error unable to extend minextents by "number" in tablespace when tables are transfered among tablespaces.
So even though the tablespace has space but its minimum extents cannot extend beyond a specified limit and hence the error.
So instead of adding space to the tablespace,the storage parameters should be tuned as shown during import.
|
|
|
|
|
|
| Re: how autoextend works [message #281369 is a reply to message #281312] |
Fri, 16 November 2007 10:02 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
| Quote: |
So there happens a mismatch between intial,next,min and max extents and the error unable to extend minextents by "number" in tablespace when tables are transfered among tablespaces.
So even though the tablespace has space but its minimum extents cannot extend beyond a specified limit and hence the error.
So instead of adding space to the tablespace,the storage parameters should be tuned as shown during import.
|
Michel,
Please verify whether my understanding is right or wrong.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
perhaps my english is not good.
