The OP failed to look up the error message in his error manual and/or the
documentation site.
This group requires when you want assistance you do the preliminary steps
yourself, and you don't leave to the group to be done what you could have
easily done yourself.
Looking up an error message is a perfect example.
Usenet is a volunteer business. If you don't want to make any effort you
should better address your request with Oracle Technical Support, as they
are getting paid for it.
Regards
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"Alun Liggins" <a.liggins_at_btinternet.com> wrote in message
news:acqeo2$c66$1_at_helle.btinternet.com...
> A little harsh Sybrand!
>
> What Oracle is saying is that the object when into a 'managed' tablespace,
> so you dont need to worry
> (so much...) about initial and next extents as Oracle will look after
that.
>
> Check out what the current tablespace extent allocation sizes are :-
>
> select * from dba_tablespaces should reveal what the default extent sizes
> are.
>
> Alun
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:uev1k0eqqh2904_at_corp.supernews.com...
> >
> > "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
> >
> >
> >
>
>
Received on Sun May 26 2002 - 07:43:34 CDT
