Re: Table Space Errors..

This may be a good time to remind poster that looking up the "alter database datafile" statement in the help will give all the information he requires...

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3ac6654a_at_news.iprimus.com.au...
> You should also consider a NEXT clause. Otherwise the file increments in
> ridiculously small bits and pieces.
>
> Hence,
>
> 'alter database datafile '/bing/bong/blah.dbf' autoextend on next 10M
> maxsize 500M'
>
> Regards
> HJR
>
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3ac5a5c5$0$12249$cc9e4d1f_at_news.dial.pipex.com...
> > 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 Mon Apr 02 2001 - 06:10:31 CDT