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 <v.schoen_at_inplan.de> 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:v.schoen_at_inplan.de
> <mailto:v.schoen_at_inplan.de>
> 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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Fri Oct 05 2001 - 11:53:55 CDT
