Since its only a development instance, I don't think the autoextend is going to be an issue. Alternatively you could run 'imp indexfile=y' and add up what you see in the storage clauses to get an approximate idea of what space is going to be needed.
hth connor --- Schoen Volker <[EMAIL PROTECTED]> wrote: > Hi list, > > I need some opinions about following question. > > I have a developer box with about 20 schemas. > Sometimes our customers send > us a export of there data which I had to import into > our develop instance. > My problem is that I don't now how much space I need > for those imports. My > solution is to create tablespaces with about 50 MB > and set autoextent on > (localy managed). I import the customers data first > time and tablespace may > use 200 mb. After some weeks I get the next export. > After import, tablespace > growth to 300 mb. > > So now my question, is it better to create a large > tablespace, because of > continouges db and hdd blocks, or does this have no > influence or small > influence on performance. I prefer to build small > tablespaces with limited > autoextent option. Reason is, that my cold backups > were quicker, cause I do > not have to reserve a lot of unused space for my > tablespaces. > > I have databases on Suse Linux, NT4 and W2K. This > question is for all > platform. If there are some platform specific > issues, please let me know. > > Hope you understand my question. > > TIA > > Volker Schoen > E-Mail: mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > http://www.inplan.de <http://www.inplan.de> > > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
