Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Tablespace object in the DBMS definition.
| Entry | Example (Oracle 8) |
|---|---|
| Enable | Enable = Yes |
| Create |
create tablespace %TABLESPACE% [%OPTIONS%] |
| Drop |
drop tablespace %TABLESPACE% [including contents [cascade constraints]] |
| Options |
datafile : composite=yes, chldmand=yes
{
<datafile_clause> : composite=yes, separator=yes, multiple=yes
{
<file_spec> : composite=yes
{
<filename> %s : squoted=yes
size %d
reuse
}
<autoextend_clause> : composite=yes
{
autoextend off
autoextend on : composite=yes
{
next %s
maxsize %s : default=UNLIMITED
}
}
}
}
minimum extent %s
<log> %s : list=logging | nologging
default storage : category=storage, composite=yes, parenthesis=yes
{
initial %d : default=10K
next %d : default=10K
minextents %d : default=1
maxextents %d
maxextents unlimited
pctincrease %d : default=50
freelists %d : default=1
optimal %d
optimal NULL
buffer_pool %s : list=keep | recycle | default
}
<online> %s : default=online, list=online | offline
<permanent> %s : default=permanent, list=permanent | temporary
|
| DefOptions | — |
| SqlListQuery |
{TABLESPACE}
SELECT TABLESPACE_NAME FROM USER_TABLESPACES ORDER BY 1
|
| SqlAttrQuery |
{TABLESPACE, OPTIONS}
SELECT TABLESPACE_NAME, 'DEFAULT STORAGE (INITIAL ' || INITIAL_EXTENT ||
' NEXT ' || NEXT_EXTENT || ' MIN_EXTENTS ' || MIN_EXTENTS ||
' MAX_EXTENTS ' || MAX_EXTENTS || ' PCTINCREASE ' || PCT_INCREASE || ') ' ||
STATUS OPTS
FROM USER_TABLESPACES
|
| SqlOptsQuery | — |
| SqlFragQuery | — |
| ModifiableAttributes | List of extended attributes that will be taken into account in the merge dialog box during database synchronization |
| ReversedStatements | List of statements that will be reverse engineered |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |