Re: 'create tablespace' question

From: Eric de Redelijkheid <ericdere_at_xs4all.nl>
Date: Sat, 09 Apr 2005 20:31:08 +0200
Message-ID: <42581f6d$0$140$e4fe514c@news.xs4all.nl>

Anno Domini 9-4-2005 19:34, mea0730 sprak aldus:

>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;
>
>
>

The autoexent clause does not apply to the entire tablespace, but only to the individual datafiles:
 DATAFILE '/oracle/oradata/PROD/appl01a.dbf' SIZE 10M autoextent on next 100 mb maxsize 2g,

                     '/oracle/oradata/PROD/appl01b.dbf' SIZE 10M 

autoextent on next 100 mb maxsize 2g,

etc. Received on Sat Apr 09 2005 - 13:31:08 CDT