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 -> Default size for undo tablespace

Default size for undo tablespace

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Sun, 04 May 2003 02:14:43 GMT
Message-ID: <c5s8bvc9b8madc2ai387qu46spupsr4h0e@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? Received on Sat May 03 2003 - 21:14:43 CDT

Original text of this message

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