Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'create tablespace' question
"mea0730" <mea0730-google_at_yahoo.com> wrote in message
news:1113068084.553866.38750_at_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;
>
You are probably importing the table as 1 big extent. You should set "compress=N" in your export script.
Matthias Received on Sat Apr 09 2005 - 12:45:41 CDT