Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default size for undo tablespace
On Sun, 04 May 2003 07:11:33 -0700, Daniel Morgan
<damorgan_at_exxesolutions.com> wrote:
I had the OMF turned on by setting the db_create_file_dest parameter, therefore Oracle will have control over namimg of files, sizings and autoextend.
>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.
Received on Sun May 04 2003 - 17:23:20 CDT