Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: hari_om@hotmail.com (Hari Om) Newsgroups: comp.databases.oracle.server Subject: Re: SYSTEM Tablespace is FULL Date: 9 Sep 2003 11:43:49 -0700 Organization: http://groups.google.com/ Lines: 56 Message-ID: References: <3F5C9BFD.E3F8EA39@remove_spam.peasland.com> <1063035071.316667@yasure> <3F5CA71A.FC41E6E4@remove_spam.peasland.com> NNTP-Posting-Host: 168.179.113.161 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1063133031 1700 127.0.0.1 (9 Sep 2003 18:43:51 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 9 Sep 2003 18:43:51 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242714 THANKS Biran and Daniel for your replies. I would try NOT to repost in different threads. My apologies. Here is the experient/research I did - please guide me: I created the DB Manually using a "plain vanilla" script which ONLY mentions datafiles, loggroups and UNDO Tablespace. It then created "vanilla" DB for me. I then executed the scripts "CATALOG.SQL" and "CATPROC.SQL" to populate the data dictionary. Here is what I see: -------------------------------------------------------------- USING DBCA to Create Database: -------------------------------------------------------------- SCHEMAS created are: CTXSYS, HR, MDSYS, ODM, ODM_MTR, OE, OLAPSYS, ORDPLUGINS, ORDSYS, OUTLN,PM,PUBLIC,QS,QS_ADM,QS_CBADM,QS_CS,QS_ES,QS_OS,SCOTT,SH,SYS, SYSTEM,WKSYS,XDB TABLESPACES Created are: CWMLITE,DRSYS,EXAMPLE,INDX,ODM,SYSTEM,TEMP,TOOLS,UNDOTBS1,USERS,XDB USERS CREATED ARE: DBCA CREATES AROUND 30 USERS. -------------------------------------------------------------- CREATING DB MANUALLY -------------------------------------------------------------- When I create DB Manually, here are my staticis: SCHEMAS Created are ONLY:OUTLN,PUBLIC,SYS,SYSTEM USERS Created are ONLY: DBSNMP,OUTLN,SYS,SYSTEM.PUBLIC TABLESPACES Created are ONLY: SYSTEM,UNDOTBS1 Also, using DBCA my SYSTEM TBLSPC holds around 400MB space and if I create DB Manually, it holds only 150MB If you compare the above staticis, you will notice a BIG Difference. So my question is if I create DB Manually, WILL I MISS ANYTHING....? Can I simply IGNORE the "extra" stuff which DBCA Created for me.... by creating DB Manually instead....? Any related informaiton on this is appreciated. Brian Peasland wrote in message news:<3F5CA71A.FC41E6E4@remove_spam.peasland.com>... > > BTW: Can't we stop cross-posting this one? It has nothing to do with > > c.d.o.misc or tools. Lets kill these other threads. > > Too often, I get caught on this....I first visit c.d.o.m and answer > threads there. Then, I come over to c.d.o.s and see the same thread. > Sometimes, there are even replies that add more information that I wish > I would have seen before I responded. And when I hit 'Reply' in my > newsreader, I don't often see that it is crossposted. I guess I have to > do a better job of that..... > > Cheers, > Brian