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