Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!ken-transit.news.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail From: "Richard Foote" Newsgroups: comp.databases.oracle.server References: Subject: Re: Default size for undo tablespace Lines: 40 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: <24tta.29219$1s1.430187@newsfeeds.bigpond.com> Date: Mon, 5 May 2003 23:02:58 +1000 NNTP-Posting-Host: 203.54.191.122 X-Trace: newsfeeds.bigpond.com 1052138878 203.54.191.122 (Mon, 05 May 2003 22:47:58 EST) NNTP-Posting-Date: Mon, 05 May 2003 22:47:58 EST Organization: Telstra BigPond Internet Services (http://www.bigpond.com) Xref: core-easynews comp.databases.oracle.server:185302 X-Received-Date: Mon, 05 May 2003 05:59:50 MST (news.easynews.com) "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. Cheers Richard