Re: autoextend system

I am also concerned about the 'autoextend' feature. I prefer more control over my databases.

I was always unsure if the database would know which filesystem to use for the datafile. I mean, where would it extend it to?

The manuals never give details.

Thanks
Gillian

• Lyall Barbour <lbarbour_at_stanford.edu> wrote: > Personally I dislike the autoextend feature. I like
  > to watch my database
  > and be a little more proactive to tablespaces
  > getting out of hand. I also
  > don't like having a million files all over the OS,
  > which autoextend could
  > possibly give you if you're not careful.
  >
  > In other words, I don't like it.
  >
  > Lyall Barbour
  >
  > At 10:25 AM 8/18/00 -0800, you wrote:
  > >I am ready to create a database, can anyone tell
  > >me if there are any advantages or disadvantages
  > >to using autoextend option
  > >for the system this is what I'd plan to use.
  > >
  > >create database PROTO
  > > maxinstances 8
  > > maxlogfiles 32
  > > maxdatafiles 500
  > >datafile
  > > '/oracle_app/files/PROTO/PROTOsys01.dbf' size
  > 100M;
  > >
  > >Thanks for any/all comments.
  > >Steff Gonos
  > >
  > >
  > >
  > >
  > >=====
  >
  >*******************************************************
  > > A day without sunshine is like, well, night.
  >
  >*******************************************************
  > >
  > >Steff Gonos
  > >steff_gonos_at_yahoo.com
  > >
  > >__________________________________________________
  > >Do You Yahoo!?
  > >Send instant messages & get email alerts with
  > Yahoo! Messenger.
  > >http://im.yahoo.com/
  > >--
  > >Author: Steff Gonos
  > > INET: steff_gonos_at_yahoo.com
  > >
  > >Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > >San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  >--------------------------------------------------------------------
  > >To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > >to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > >the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > >(or the name of mailing list you want to be removed
  > from). You may
  > >also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Author: Lyall Barbour
  > INET: lbarbour_at_stanford.edu
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---