Re: ORA-25150: ALTERING of extent parameters not permitted

"Brandon" <brandon_oh_at_yahoo.com> wrote in message news:a03c2125.0205242154.231b2e2a_at_posting.google.com...
> Hi,
>
> I had just migrated my production database from Oracle 7.3.3 to Oracle
> 8.1.7
> by using exporting and importing by user.
>
> I noticed after the import, the storage parameter (NEXT_EXTENT) of the
> tables being imported was zero. But when i tried to alter this
> parameter by using the following sql command "alter table user.table
> storage (NEXT 20K);", it gives
> me an error message an error message of "ORA-25150: ALTERING of extent
> parameters not permitted".
>
> Have anyone encounter this problem before ??
> And how do you solve it ? Thanks for helping : )
>
> rgds,
> Brandon

A simple search on the error message in the docs resulted in

ORA-25150 ALTERING of extent parameters not permitted

Cause: An attempt was made to alter the extent parameters for a segment in a tablespace with autoallocate or uniform extent allocation policy.

Action: Remove the appropriate extent parameters from the command.

Next time, please try to research the error manual before posting

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address