Specifies DEFAULT to indicate the default buffer pool. Puts blocks from the segment into the RECYCLE buffer pool. Puts blocks from the segment into the KEEP buffer pool. When you select this option, select one of the following options for Buffer Pool: KEEP Select this check box if you want to specify a default buffer pool. This option appears only when you are in the Oracle Table Editor or the Oracle Materialized Views Editor. The value of this parameter is expressed as a whole number and interpreted as a percentage. Specify the space to be reserved for each data block for future expansion.
Specify the limit Oracle should use to determine when additional rows can be added. Space UsageĮnter values for the following options for Space Usage: PCTFREE If you select this option, enter a value in the text box. When you select this option, select one of the following options for Maxextents: UNLIMITED VALUE Specifies the total number of extents to allocate when the object is created. Specifies the percent by which the third and subsequent extents grow over the preceding extent. Specifies in bytes the size of the next extent to allocate to the object. Specifies in bytes the size of the object's first extent. ExtentsĮnter values for the following options for Extents: INITIAL If you need to edit the properties of a tablespace you select, click the button to open the Oracle Tablespace Editor. The following describes the options for the Oracle Storage Properties Dialog: TABLESPACEĪ drop-down list box where you can select a tablespace from the current model to which you assign storage properties. Use the Oracle Storage Properties Dialog to assign various storage properties for an Oracle tablespace. Open the Oracle Storage Properties Dialog when you click on the Storage Properties button in various property editors. Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Storage Properties Dialog
0 kommentar(er)
