SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:13 AM
| ||||
| ||||
 DMS Tablespaces What happens if the "number of pages" are not specifies in the "Create Tablespace ..." DDL for DMS tablespaces. Can we have unlimited number of pages or may be an auto-extend feature, where if the existing number of pages are coming to an end the system will automatically allocate more pages. Or is the feature possible only for SMS tablespaces? Thanks, Yasaswi      |
|
02-27-2008, 02:13 AM
| |||
| |||
| Re: DMS Tablespaces I think that the SIZE is mandatory in DMS tablespace create statement. You will have to specify the size of the tablespace in the form of: Number of Pages (default) Kilobytes --> (4096K), Megabytes --> (40M), Gigabytes --> (4G). hth, dotyet yasaswi@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa862233.0411091149.135f2103@posting.google. com>... > What happens if the "number of pages" are not specifies in the "Create > Tablespace ..." DDL for DMS tablespaces. Can we have unlimited number > of pages or may be an auto-extend feature, where if the existing > number of pages are coming to an end the system will automatically > allocate more pages. Or is the feature possible only for SMS > tablespaces? > Thanks, > Yasaswi |
|
02-27-2008, 02:13 AM
| ||||
| ||||
| Re: DMS Tablespaces yasaswi@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa862233.0411091149.135f2103@posting.google. com>... > What happens if the "number of pages" are not specifies in the "Create > Tablespace ..." DDL for DMS tablespaces. Can we have unlimited number > of pages or may be an auto-extend feature, where if the existing > number of pages are coming to an end the system will automatically > allocate more pages. Or is the feature possible only for SMS > tablespaces? > Thanks, > Yasaswi Only possible with SMS tablespaces. |
Linear Mode
