ora-1632 max extents

[loriek]

I have a max extents error. Does anyone know how to fix?

 

[SantaMufasa]

alter table <table_name> max_extents {<some larger number> | unlimited};

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”

 

[loriek]

Thank you for a prompt reply. Is that true of indexes as well? My apologies, should have given that up front. Also, 8.1.6 on windows.

 

[SantaMufasa]

Yes...applies to indexes, as well.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”