Tablespace growth

From: KMART <kmarti_at_comcast.net>
Date: 27 Apr 2005 04:01:35 -0700
Message-ID: <1114599695.921412.252270@l41g2000cwc.googlegroups.com>

Database: Oracle 10g OS: Windows XP Professional.

How do I get a tablespace to grow until I run out of storage? 200g is available!
Example create statement
Create tablespace abc datafile 'c:\oracle\oradata\mydb\abc_01.dbf' size 1502M
autoextend on next 1502M MAXSIZE unlimited extent management local uniform size 500M;

I altered the tablespace to add four datafiles. The problem is 1st datafile is extends to 15012M but the datefiles added after initial tablespace creation are not used at all.

What am I missing? I do not want to use the default 65K extent sizes....

Thank You
Ken Martin
kmarti_at_comcast.net Received on Wed Apr 27 2005 - 06:01:35 CDT