Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!west.cox.net!cox.net!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news3.calgary.shaw.ca.POSTED!not-for-mail X-Trace-PostClient-IP: 24.80.236.234 From: Peter Newsgroups: comp.databases.oracle.server Subject: Re: Default size for undo tablespace Organization: Bright Message-ID: References: <24tta.29219$1s1.430187@newsfeeds.bigpond.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 43 Date: Mon, 05 May 2003 18:42:54 GMT NNTP-Posting-Host: 24.69.255.232 X-Complaints-To: abuse@shaw.ca X-Trace: news3.calgary.shaw.ca 1052160174 24.69.255.232 (Mon, 05 May 2003 12:42:54 MDT) NNTP-Posting-Date: Mon, 05 May 2003 12:42:54 MDT Xref: core-easynews comp.databases.oracle.server:185333 X-Received-Date: Mon, 05 May 2003 11:42:23 MST (news.easynews.com) On Mon, 5 May 2003 23:02:58 +1000, "Richard Foote" wrote: >"Peter" wrote in message >news: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? > >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.