Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Default size for undo tablespace

Re: Default size for undo tablespace

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Sun, 04 May 2003 22:23:20 GMT
Message-ID: <vi4bbvonmsb5a5sfqc1jtp9jb3cicf8s04@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US