| how to know the default next_extent, pct_increace on tables? [message #280929] |
Thu, 15 November 2007 03:59  |
thorin666
Messages: 144
Registered: March 2007
|
Senior Member |
|
|
Hi
i have a problem. My boss ask me for the max(next_extent) of each table and tablespace
i was searching on dba_tables, dba_segments, and dba_tablespaces
but i dind nulls values on all that tables
i find that when you create a table, storage clause is not a must,
in this case i think that oracle takes the default or the tablespace default but if you create a tablespace without the storage clause, oracle takes the default next_extent and pct_increase
Does anyone knows how to determine the default next_extent
|
|
|
|
|
|
| Re: how to know the default next_extent, pct_increace on tables? [message #280938 is a reply to message #280934] |
Thu, 15 November 2007 04:10  |
thorin666
Messages: 144
Registered: March 2007
|
Senior Member |
|
|
| Michel Cadot wrote on Thu, 15 November 2007 04:07 |
If you are using locally managed tablespaces, these parameters are no more used.
Regards
Michel
|
sorry, yes in my laptop i am using oracle9
but in the clients i have oracle oracle 7 and 8
i think that in the clients are dictionary management
if it's the case, i must to search into dba_tables, after that dba_segment and finaly dba_tablespaces?
or i am wrong?
Regards
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
