- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- problem with max extents oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 05:45 AM
тАО12-06-2000 05:45 AM
I have east problem with oracle 7,3,2,3 I cannot extend but indice, that I can do? and as I can do it.
This is the error :
he following database error has occurred: ORA-01632: max # extents (505) reached in index CHEMLMS.RS1
Thanks in advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 06:11 AM
тАО12-06-2000 06:11 AM
Re: problem with max extents oracle
If you have access as database administrator,
you should be able to fix this.
You should enhance the next parameter by factor 20 and change the maxextents.
Open the svrmgrl and do the connect internal.
Or open sqlplus as system/passwd.
Then type as shown in sample :
alter index owner.indexname storage (next ..M maxtextents 515 )
;
another thing is to make a note of the storage
parameters of that index, drop it, resize the parameters and rebuild it.
if you need more info, let me know.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 06:13 AM
тАО12-06-2000 06:13 AM
Solutionalter index ... storage (maxextents unlimited);
This will fix your problem. Then you can have a deeper look to set more adequate next extent size.
However, the name of segment you mention looks like a rollback segment. If it is right consider dropping it and recreate it.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 06:25 AM
тАО12-06-2000 06:25 AM
Re: problem with max extents oracle
Bruno is right, you can go for unlimited extents, but that could give some unwanted results later. If you limit the extents,
you can keep it under control.
rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 06:31 AM
тАО12-06-2000 06:31 AM
Re: problem with max extents oracle
ORA-00406: COMPATIBLE parameter needs to be 7.3.0.0.0 or greater
but the version is 7.3.2.3, I no understand !!!
Thanks for your time
Mauro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 06:49 AM
тАО12-06-2000 06:49 AM
Re: problem with max extents oracle
go to the init.ora file.
You will find the compatible parameter in there. Set it to the requested value.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2000 07:36 AM
тАО12-06-2000 07:36 AM
Re: problem with max extents oracle
I found it the parameters
compatible = 7.3.0.0
And I can Fix the problem.
Thanks for all.
Mauro