| max_extents almost reached [message #53948] |
Sun, 20 October 2002 13:21  |
Albert
Messages: 20
Registered: October 2002
|
Junior Member |
|
|
Please help me out here. We have an 8.0.6.1.0 EE system on solaris 2.6. (due to
a certain financial application, we cannot upgrade to a decent Oracle
version like 8.1.7.x.y).
We have about 30 tablespaces, db size is about 16 GB. Most tablespaces are
around 600M. db blocksize=16384. I have plenty of diskspace free. I don't have a
testmachine :-((
A certain table reaches its maximum number of extents: its now at 980 extents
and the max_extents is 1024. (The initial and next extent was only defined at
160 K). I know that in 8i one can issue the "ALTER TABLE.. MOVE" command, which
is not possible in my case. Also, this particular table has many triggers
defined, an there are also many PK-FK relations with other tables. I do not know
how to rebuild this table with a better extent definition. Can I just export the
table and then imp it again, but what about triggers and PK-FK relations?
Can I use "insert into temp_table as select from ..."?
Or can I just increase the max number of extents (in 8.0.6) above 1024?
Thanks for your support!!
|
|
|
|
| Re: max_extents almost reached [message #53949 is a reply to message #53948] |
Mon, 21 October 2002 01:25  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
|
U can use exp/imp but U shold rebuild all the tables with new definition. Or U can just, change the "NEXT_EXTENT" and the "MAX_EXTENTS" to a new higher value ( 1024 is not the highest value )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
