Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Default size for undo tablespace
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