Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'create tablespace' question

'create tablespace' question

From: mea0730 <mea0730-google_at_yahoo.com>
Date: 9 Apr 2005 10:34:44 -0700
Message-ID: <1113068084.553866.38750@g14g2000cwa.googlegroups.com>


Sorry for such a basic question!!

I want to load/import data into a new tablespace that has 10 datafiles.  I want each datafile to have a very small initial allocation size (10 M) with AUTOEXEND on. I want each datafile to be limited to 2000M so that the max size of the tablespace will be 20GIG. Is there a way to do this? I've not been able to do this. I really don't want to "pre-size" the datafiles to 2000M each.

If I create a tablespace with the following syntax and run an import, all the data goes into the last data file. It's not spread across the datafiles.

Thanks!!!!
Mike

CREATE TABLESPACE appl01

  DATAFILE    '/oracle/oradata/PROD/appl01a.dbf' SIZE 10M,

'/oracle/oradata/PROD/appl01b.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01c.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01d.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01e.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01f.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01g.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01h.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01i.dbf' SIZE 10M,
'/oracle/oradata/PROD/appl01j.dbf' SIZE 10M
AUTOEXTEND ON NEXT 100M MAXSIZE 20G EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
Received on Sat Apr 09 2005 - 12:34:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US