 Problem about extents [message #213690] |
Thu, 11 January 2007 22:04  |
chara
Messages: 81
Registered: April 2005
Location: th
|
Member |
|
|
Dear all,
I used database health check from toad and got message as following:
[Segments with > 100 extents] Exec Time 0 seconds
! TABLE user01.ttable: 250 Extents
After then i create new tablespace and export this table,drop table and import to new tablespace.then i ran health check again and got message:
[Segments with > 100 extents] Exec Time 0 seconds
! TABLE user01.ttable: 410 Extents
oracle version 9.2.0.7
tablespace extent management : local
segment space management : auto
What happend? How i will fix this problem?
Thanks for advance
Chara
|
|
|
|
|
|
| Re: Problem about extents [message #213829 is a reply to message #213690] |
Fri, 12 January 2007 08:06  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
What kind of inferior product is TOAD that it claims 100 extents is bad? Is this version 1.0 from 1980?
This was the whole purpose of locally managed tablespaces, so people wouldn't have to waste their time caring about extents.
I don't use TOAD, but I see many people do so I assumed it was a pretty good product, but now I'd view with skepticism any other message from it's so called health check.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
