Partitioning Tablespace Creation

 < Day Day Up > 



These commands create tablespaces for separate partitions created on the Accounts schema GeneralLedger table, used by partitioning examples in Chapter 17. Other examples in Chapter 17 creating partitions for other tables use similar tablespace creation scripts. Not all scripts are included here.

create tablespace DATAGLP1999 logging datafile 'c:\oracle\oradata\dual\dataglP1999.dbf' size 6M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace DATAGLP2000 logging datafile 'c:\oracle\oradata\dual\dataglP2000.dbf' size 6M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace DATAGLP2001 logging datafile 'd:\oracle\oradata\dual\dataglP2001.dbf' size 6M autoextend on next 1M maxsize unlimited extent management local uniform size 1M; create tablespace DATAGLP2002 logging datafile 'e:\oracle\oradata\dual\dataglP2002.dbf' size 6M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace INDXGLP1999 logging datafile 'c:\oracle\oradata\dual\indxglP1999.dbf' size 2M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace INDXGLP2000 logging datafile 'c:\oracle\oradata\dual\indxglP2000.dbf' size 2M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace INDXGLP2001 logging datafile 'd:\oracle\oradata\dual\indxglP2001.dbf' size 2M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     create tablespace INDXGLP2002 logging datafile 'e:\oracle\oradata\dual\indxglP2002.dbf' size 2M autoextend on next 1M maxsize unlimited extent management local uniform size 1M;     alter user accounts quota unlimited on DATAGLP1999       quota unlimited on DATAGLP2000 quota unlimited           on DATAGLP2001       quota unlimited on DATAGLP2002;     alter user accounts quota unlimited on INDXGLP1999       quota unlimited on INDXGLP2000 quota unlimited           on INDXGLP2001        quota unlimited on INDXGLP2002;



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net