Re: 'create tablespace' question

From: mea0730 <mea0730-google_at_yahoo.com>
Date: 9 Apr 2005 12:50:43 -0700
Message-ID: <1113076243.121687.11980@l41g2000cwc.googlegroups.com>

Yes, it works if you put the AUTOEXTEND and MAXFILE on "every" datafile. It's running right now and allocating across all the datafiles in a "round-robin" orders Doing exactly what I wanted!

Mike

CREATE TABLESPACE appl01
  DATAFILE '/oracle/oradata/PROD/appl01a.dbf' SIZE 1M AUTOEXTEND ON NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01b.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01c.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01d.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01e.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01f.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01g.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01h.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01i.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G,
'/oracle/oradata/PROD/appl01j.dbf' SIZE 1M AUTOEXTEND ON
NEXT 10M MAXSIZE 2G
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE
  SEGMENT SPACE MANAGEMENT AUTO; Received on Sat Apr 09 2005 - 14:50:43 CDT