Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default size for undo tablespace
"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
news:c5s8bvc9b8madc2ai387qu46spupsr4h0e_at_4ax.com...
> 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?
Hi Peter,
Not only is the 67M data file puzzling, but so are the others as the default size of an OMF is (generally) 100M.
Cheers
Richard Received on Mon May 05 2003 - 08:02:58 CDT