In article <932127084.3503_at_www.remarq.com>,
Greg Akins <insomnia_at_a1usa.net> wrote:
> So I have a job using Oracle (mostly pretty simple
> development stuff). Problem is, the boss hasn't hired a
> DBA, so I have to try to learn a lot of this myself. And I
> just started using Oracle a couple months ago.
>
> So, for starters, I am trying to set up a test database to
> do some playing... Oracle 8.0.5 on NT. I used the
> database wizard to create a 'medium' sized database.
>
> Then I created some Tablespaces for my data.
>
> For example
>
> CREATE TABLESPACE APPL_DATA
> DATAFILE 'APPL_DATA'
> SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 1000M
> DEFAULT STORAGE
> ( INITIAL 50M NEXT 5M
> MINEXTENTS 1
> MAXEXTENTS 10 PCTINCREASE 1 )
> MINIMUM EXTENT 50M;
>
> No to me this reads as a 100M file which can autoextend to
> 1Gig. The tablespace having 50M initial extendable to 500M.
>
> But when I start populating with data I get a message that
> the tablespace can't be extended anymore. Even though the
> total size of the result set should be only 35megs.
>
> Is something in the database parameters preventing me from
> growing the tablespaces. Or do I have a Tablespace setting
> wrong? Or, I am incorrectly interpreting my CREATE
> statement?
>
> I realize these are pretty broad questions. A pointer to a
> website, or book that will help would be appreciated. As
> would any specific pointers.
>
> -greg
> insomnia_at_a1usa.net
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start
Here (tm) ****
>
Greg. The default storage paramater apply to objects you create in the
tablespace without using a storage clause. Since your file is 100M in
size and your initial table extent is 50M because of overhead you will
get only one extent allocation in your tablespace before it
autoextends. Since you have set the autoextent size to 10M which is
less than the requested initial extent of your second object you are
going to have a problem. Alter your tablespace object defaults to a
more reasonable size or increase the size of your file extents.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 09:01:00 CDT
