Property Tablespace

Namespace

YndigoBlue.Velocity.Data.Oracle

Assembly

YndigoBlue.Velocity.dll

Tablespace

Gets or sets the tablespace for database objects.

public string Tablespace { get; set; }

Property Value

string

Remarks

A tablespace is a logical storage container in Oracle that holds database objects (tables, indexes, etc.). This property specifies the tablespace where all schema users and tables will be created.

warning

This property is mandatory when using BuildSchema() or CreateTable(). Oracle creates a separate locked database user per Velocity schema, and that user must be assigned a tablespace with quota at creation time. Leaving this unset will produce invalid SQL and the operation will fail.

If you are unsure which tablespace to use, check with your DBA or query the database default:

SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE'