Re: Default size for undo tablespace

Daniel Morgan wrote:
>
> Peter wrote:
>
> > I had the OMF turned on which was supposed to create an undo
> > tablespace 10m in size.
> >
> > I ran the following statement I did not set the undo_managemnt
> > paramater. But what I got is an undo tablespace of 67m.
> >
> > create database db
> > default temporary tablespace temptbs
> > undo tablespace undotbs;
> >
> > If I ran the following statement instead and with the undo_managemnt
> > paramater set to auto, then I got an undo tablespace of 10m
> >
> > create database db
> > default temporary tablespace temptbs;
> >
> > Also, If I ran the following statement and with the undo_managemnt
> > paramater set to auto, then I got an undo tablespace of 10m
> >
> > create database db
> > default temporary tablespace temptbs
> > undo tablespace undotbs;
> >
> > My question is why did the first statement give me an undo tablespace
> > of 67m?
>
> Can't answer you question but can you answer this question?
>
> Why would you run a create tablespace statement without specifying
> parameters?
>
> No datafile name?
> No sizings?
> No autoextend statement?
>
> Oracle should have just given you an ORA error and refused to do any more
> than that.
>
> You should never issue a create database statement without specifying
> basic values, names, and locations.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)

You'll find that Oracle are now recommending that you do exactly that (ie specify no files) and let the init.ora settings take care of it. (This is not a school of thought that I subscribe to, but it is the way Oracle appears to be going)

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"