Newbie question about Tablespaces (and database creation).

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) ****