DF_FILE_TABLESPACE_NAME¶

Applies to: ORAFlex PGFlex

A tablespace is a container of segments (objects that have an allotted amount of space), i.e. tables and indexes. This attribute is used to get or set the name of the tablespace being used for the data tables. To set or get the tablespace name for indexes, use the DF_FILE_INDEXTABLESPACE_NAME attribute. Setting the tablespace name can only be done during a Structure_Start (during table creation). Getting the name, however can be done at anytime. Note that when setting the tablespace name, it must be set to an already existing tablespace, this attribute does not create the tablespace itself. Even though MYSQL uses tablespaces, this this attribute is only supported in Oracle and PostgreSQL.

Syntax

Get_Attribute DF_FILE_TABLESPACE_NAME of {FileNumber} to {variable}
Set_Attribute DF_FILE_TABLESPACE_NAME of {FileNumber} 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

DF_FILE_INDEXTABLESPACE_NAME