Re: Default size for undo tablespace

On Mon, 5 May 2003 23:02:58 +1000, "Richard Foote" <richard.foote_at_bigpond.com> wrote:

>"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.
>

In general the default is 100M for system, datafile and log files but for the undo tablespace the default is 10m. Received on Mon May 05 2003 - 13:42:54 CDT