Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 'create tablespace' question
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,Received on Sat Apr 09 2005 - 12:34:44 CDT
'/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;