日期:2014-05-16 浏览次数:20617 次
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