append the MAXSIZE parameter
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Joe Blow" <zuestra_at_hotmail.com> wrote in message
news:l16bct4bieif4tc8ajef5pg3aakt92nqhk_at_4ax.com...
> How?
>
>
> On Sat, 31 Mar 2001 01:31:56 GMT, "Mike Moore" <hicamel_at_mail.home.com>
wrote:
>
> >I believe that you can set a limit on autoextend.
> >Mike
> >
> >Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> >news:tca634c1ijgm04_at_beta-news.demon.nl...
> >>
> >> "Pestilence" <adonis__at_hotmail.com> wrote in message
> >> news:kQ7x6.181681$t67.2923958_at_news1.rdc1.il.home.com...
> >> > I just wanted to know if there is a way to have the table spaces
manage
> >> > themselves. There is a lot of data importing going on and I am
always
> >> > increasing table space. I was just wondering if there is something
that
can
> >> > help me out.
> >> >
> >> >
> >>
> >> There is of course autoextend on tablespaces.
> >> However this idea should be placed in the same category as pctincrease:
you
> >> usually create more disasters by introducing it than by avoiding to use
it.
> >> If you set the tablespaces to autoextend eventually they fill up this
disk.
> >> The result of that will be a lot of importing going on.
> >>
> >> Regards,
> >>
> >> Sybrand Bakker, Oracle DBA
> >>
> >>
> >>
> >
>
Received on Sat Mar 31 2001 - 03:22:44 CST
