DF_FILE_INDEXTABLESPACE_NAME¶

Applies to: ORAFlex PGFlex

This attribute is used to get or set the name of the tablespace being used for the index segment of a database. For a description of tablespaces, see the description above for DF_FILE_TABLESPACE_NAME. Similar to the Tablespace name attribute, setting the index tablespace name can only be done during creation and must use an already existing tablespace as the variable. This attribute is only available for Oracle and Postgre.

Syntax

Get_Attribute DF_FILE_INDEXTABLESPACE_NAME of {File Number} to {variable}
Set_Attribute DF_FILE_INDEXTABLESPACE_NAME of {File Number} to {variable}

Parameter

Description

FileNumber

Number of the file

variable

Name of the Tablespace

Example

Handle hFile
move 0 to hFile
Structure_Start hFile "ORA_DRV"
    Set_Attribute DF_FILE_TABLESPACE_NAME      of hFile To "USERS"
    Set_Attribute DF_FILE_INDEXTABLESPACE_NAME of hFile To "INDXS"

    // More table creation here
    //
Structure_End hFile DF_STRUCTEND_OPT_NONE "." 0