日期:2014-05-16 浏览次数:20687 次
create tablespace语法树
>>-CREATE
--+-----------------------+---------------------------->
?????????? +-LARGE-----------------+?? 
?????????? +-REGULAR---------------+?? 
?????????? | .-SYSTEM-.??????????? |?? 
?????????? '-+--------+--TEMPORARY-'?? 
???????????? '-USER---'??????????????? 
>--TABLESPACE--tablespace-name---------------------------------->
>--+-----------------------+-->
?? |???? .-DATABASE PARTITION GROUP-.????????????????????????? |?? 
?? '-IN--+--------------------------+--db-partition-group-name-'?? 
>--+--------------------------+--------------------------------->
?? '-PAGESIZE--integer--+---+-'?? 
?????????????????????? '-K-'???? 
?? .-MANAGED BY--AUTOMATIC STORAGE--| size-attributes |---------------------.?? 
>--+------------------------------------+-->
?? '-MANAGED BY--+-SYSTEM--| system-containers |--------------------------+-'?? 
???????????????? '-DATABASE--| database-containers |--| size-attributes |-'???? 
>--+---------------------------------+-------------------------->
?? '-EXTENTSIZE--+-number-of-pages-+-'?? 
???????????????? '-integer--+-K-+--'???? 
??????????????????????????? '-M-'??????? 
>--+-----------------------------------+------------------------>
?? '-PREFETCHSIZE--+-AUTOMATIC-------+-'?? 
?????????????????? +-number-of-pages-+???? 
?????????????????? '-integer--+-K-+--'???? 
????????????????????????????? +-M-+??????? 
????????????????????????????? '-G-'??????? 
>--+-----------------------------+------------------------------>
?? '-BUFFERPOOL--bufferpool-name-'?? 
>--+----------------------------------+------------------------->
?? '-OVERHEAD--number-of-milliseconds-'?? 
>--+------------------------+----------------------------------->
?? +-NO FILE SYSTEM CACHING-+?? 
?? '-FILE SYSTEM CACHING----'?? 
>--+--------------------------------------+--------------------->
?? '-TRANSFERRATE--number-of-milliseconds-'?? 
>--+---------------------------------+-------------------------><
?? '-DROPPED TABLE RECOVERY--+-ON--+-'?? 
???????????????????????????? '-OFF-'???? 
size-attributes
|--+---------------------+--+-----------------------------+----->
?? '-AUTORESIZE--+-NO--+-'? '-INITIALSIZE--integer--+-K-+-'?? 
???????????????? '-YES-'??????????????????????????? +-M-+???? 
??????????????????????????????????????????????????? '-G-'???? 
>--+------------------------------------+----------------------->
?? '-INCREASESIZE--integer--+-PERCENT-+-'?? 
??????????????????????????? '-+-K-+---'???? 
????????????????????????????? +-M-+???????? 
????????????????????????????? '-G-'???????? 
>--+-----------------------------+------------------------------|
?? '-MAXSIZE--+-integer--+-K-+-+-'?? 
????????????? |????????? +-M-+ |???? 
????????????? |????????? '-G-' |???? 
????????????? '-NONE-----------'???? 
system-containers
?? .----------------------------------.?? 
?? |?????????? .-,------------------.???????????????????????????????????? |?? 
?? V?????????? V??????????????????? |???????????????????????????????????? |?? 
|----USING--(----'container-string'-+--)--+-----------------------------+-+--|
????????????????????????????????????????? '-| on-db-partitions-clause |-'???? 
database-containers
?? .--------------------------.?? 
?? V????????????????????????????????????????????????????????????? |?? 
|----US