Tablespace¶
- class oci.database_management.models.Tablespace(**kwargs)¶
Bases:
objectThe details of a tablespace.
Attributes:
A constant which can be used with the allocation_type property of a Tablespace.
A constant which can be used with the allocation_type property of a Tablespace.
A constant which can be used with the allocation_type property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the compress_for property of a Tablespace.
A constant which can be used with the default_index_compression property of a Tablespace.
A constant which can be used with the default_index_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory_compression property of a Tablespace.
A constant which can be used with the default_in_memory property of a Tablespace.
A constant which can be used with the default_in_memory_distribute property of a Tablespace.
A constant which can be used with the default_in_memory_distribute property of a Tablespace.
A constant which can be used with the default_in_memory_distribute property of a Tablespace.
A constant which can be used with the default_in_memory_distribute property of a Tablespace.
A constant which can be used with the default_in_memory_duplicate property of a Tablespace.
A constant which can be used with the default_in_memory_duplicate property of a Tablespace.
A constant which can be used with the default_in_memory_duplicate property of a Tablespace.
A constant which can be used with the default_in_memory property of a Tablespace.
A constant which can be used with the default_in_memory_priority property of a Tablespace.
A constant which can be used with the default_in_memory_priority property of a Tablespace.
A constant which can be used with the default_in_memory_priority property of a Tablespace.
A constant which can be used with the default_in_memory_priority property of a Tablespace.
A constant which can be used with the default_in_memory_priority property of a Tablespace.
A constant which can be used with the default_in_memory_service property of a Tablespace.
A constant which can be used with the default_in_memory_service property of a Tablespace.
A constant which can be used with the default_in_memory_service property of a Tablespace.
A constant which can be used with the default_in_memory_service property of a Tablespace.
A constant which can be used with the default_table_compression property of a Tablespace.
A constant which can be used with the default_table_compression property of a Tablespace.
A constant which can be used with the extent_management property of a Tablespace.
A constant which can be used with the extent_management property of a Tablespace.
A constant which can be used with the index_compress_for property of a Tablespace.
A constant which can be used with the index_compress_for property of a Tablespace.
A constant which can be used with the index_compress_for property of a Tablespace.
A constant which can be used with the logging property of a Tablespace.
A constant which can be used with the logging property of a Tablespace.
A constant which can be used with the lost_write_protect property of a Tablespace.
A constant which can be used with the lost_write_protect property of a Tablespace.
A constant which can be used with the lost_write_protect property of a Tablespace.
A constant which can be used with the predicate_evaluation property of a Tablespace.
A constant which can be used with the predicate_evaluation property of a Tablespace.
A constant which can be used with the retention property of a Tablespace.
A constant which can be used with the retention property of a Tablespace.
A constant which can be used with the retention property of a Tablespace.
A constant which can be used with the segment_space_management property of a Tablespace.
A constant which can be used with the segment_space_management property of a Tablespace.
A constant which can be used with the shared property of a Tablespace.
A constant which can be used with the shared property of a Tablespace.
A constant which can be used with the shared property of a Tablespace.
A constant which can be used with the status property of a Tablespace.
A constant which can be used with the status property of a Tablespace.
A constant which can be used with the status property of a Tablespace.
A constant which can be used with the type property of a Tablespace.
A constant which can be used with the type property of a Tablespace.
A constant which can be used with the type property of a Tablespace.
A constant which can be used with the type property of a Tablespace.
Gets the allocated_size_kb of this Tablespace.
Gets the allocation_type of this Tablespace.
Gets the block_size_bytes of this Tablespace.
Gets the compress_for of this Tablespace.
Gets the datafiles of this Tablespace.
Gets the default_cell_memory of this Tablespace.
Gets the default_in_memory of this Tablespace.
Gets the default_in_memory_compression of this Tablespace.
Gets the default_in_memory_distribute of this Tablespace.
Gets the default_in_memory_duplicate of this Tablespace.
Gets the default_in_memory_priority of this Tablespace.
Gets the default_in_memory_service of this Tablespace.
Gets the default_in_memory_service_name of this Tablespace.
Gets the default_index_compression of this Tablespace.
Gets the default_table_compression of this Tablespace.
Gets the extent_management of this Tablespace.
Gets the free_space_kb of this Tablespace.
Gets the index_compress_for of this Tablespace.
Gets the is_bigfile of this Tablespace.
Gets the is_chunk_tablespace of this Tablespace.
Gets the is_default of this Tablespace.
Gets the is_encrypted of this Tablespace.
Gets the is_force_logging of this Tablespace.
Gets the is_plugged_in of this Tablespace.
Gets the logging of this Tablespace.
Gets the lost_write_protect of this Tablespace.
Gets the max_size_kb of this Tablespace.
[Required] Gets the name of this Tablespace.
Gets the predicate_evaluation of this Tablespace.
Gets the retention of this Tablespace.
Gets the segment_space_management of this Tablespace.
Gets the shared of this Tablespace.
Gets the status of this Tablespace.
Gets the temp_group of this Tablespace.
[Required] Gets the type of this Tablespace.
Gets the used_percent_allocated of this Tablespace.
Gets the used_percent_available of this Tablespace.
Gets the used_space_kb of this Tablespace.
Gets the user_size_kb of this Tablespace.
Methods:
__init__(**kwargs)Initializes a new Tablespace object with values from keyword arguments.
- ALLOCATION_TYPE_SYSTEM = 'SYSTEM'¶
A constant which can be used with the allocation_type property of a Tablespace. This constant has a value of “SYSTEM”
- ALLOCATION_TYPE_UNIFORM = 'UNIFORM'¶
A constant which can be used with the allocation_type property of a Tablespace. This constant has a value of “UNIFORM”
- ALLOCATION_TYPE_USER = 'USER'¶
A constant which can be used with the allocation_type property of a Tablespace. This constant has a value of “USER”
- COMPRESS_FOR_ADVANCED = 'ADVANCED'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “ADVANCED”
- COMPRESS_FOR_ARCHIVE_HIGH = 'ARCHIVE_HIGH'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “ARCHIVE_HIGH”
- COMPRESS_FOR_ARCHIVE_LOW = 'ARCHIVE_LOW'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “ARCHIVE_LOW”
- COMPRESS_FOR_BASIC = 'BASIC'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “BASIC”
- COMPRESS_FOR_DIRECT_LOAD_ONLY = 'DIRECT_LOAD_ONLY'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “DIRECT_LOAD_ONLY”
- COMPRESS_FOR_FOR_ALL_OPERATIONS = 'FOR_ALL_OPERATIONS'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “FOR_ALL_OPERATIONS”
- COMPRESS_FOR_QUERY_HIGH = 'QUERY_HIGH'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “QUERY_HIGH”
- COMPRESS_FOR_QUERY_LOW = 'QUERY_LOW'¶
A constant which can be used with the compress_for property of a Tablespace. This constant has a value of “QUERY_LOW”
- DEFAULT_INDEX_COMPRESSION_DISABLED = 'DISABLED'¶
A constant which can be used with the default_index_compression property of a Tablespace. This constant has a value of “DISABLED”
- DEFAULT_INDEX_COMPRESSION_ENABLED = 'ENABLED'¶
A constant which can be used with the default_index_compression property of a Tablespace. This constant has a value of “ENABLED”
- DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_HIGH = 'FOR_CAPACITY_HIGH'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “FOR_CAPACITY_HIGH”
- DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_LOW = 'FOR_CAPACITY_LOW'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “FOR_CAPACITY_LOW”
- DEFAULT_IN_MEMORY_COMPRESSION_FOR_DML = 'FOR_DML'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “FOR_DML”
- DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_HIGH = 'FOR_QUERY_HIGH'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “FOR_QUERY_HIGH”
- DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_LOW = 'FOR_QUERY_LOW'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “FOR_QUERY_LOW”
- DEFAULT_IN_MEMORY_COMPRESSION_NO_MEMCOMPRESS = 'NO_MEMCOMPRESS'¶
A constant which can be used with the default_in_memory_compression property of a Tablespace. This constant has a value of “NO_MEMCOMPRESS”
- DEFAULT_IN_MEMORY_DISABLED = 'DISABLED'¶
A constant which can be used with the default_in_memory property of a Tablespace. This constant has a value of “DISABLED”
- DEFAULT_IN_MEMORY_DISTRIBUTE_AUTO = 'AUTO'¶
A constant which can be used with the default_in_memory_distribute property of a Tablespace. This constant has a value of “AUTO”
- DEFAULT_IN_MEMORY_DISTRIBUTE_BY_PARTITION = 'BY_PARTITION'¶
A constant which can be used with the default_in_memory_distribute property of a Tablespace. This constant has a value of “BY_PARTITION”
- DEFAULT_IN_MEMORY_DISTRIBUTE_BY_ROWID_RANGE = 'BY_ROWID_RANGE'¶
A constant which can be used with the default_in_memory_distribute property of a Tablespace. This constant has a value of “BY_ROWID_RANGE”
- DEFAULT_IN_MEMORY_DISTRIBUTE_BY_SUBPARTITION = 'BY_SUBPARTITION'¶
A constant which can be used with the default_in_memory_distribute property of a Tablespace. This constant has a value of “BY_SUBPARTITION”
- DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATE = 'DUPLICATE'¶
A constant which can be used with the default_in_memory_duplicate property of a Tablespace. This constant has a value of “DUPLICATE”
- DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATE_ALL = 'DUPLICATE_ALL'¶
A constant which can be used with the default_in_memory_duplicate property of a Tablespace. This constant has a value of “DUPLICATE_ALL”
- DEFAULT_IN_MEMORY_DUPLICATE_NO_DUPLICATE = 'NO_DUPLICATE'¶
A constant which can be used with the default_in_memory_duplicate property of a Tablespace. This constant has a value of “NO_DUPLICATE”
- DEFAULT_IN_MEMORY_ENABLED = 'ENABLED'¶
A constant which can be used with the default_in_memory property of a Tablespace. This constant has a value of “ENABLED”
- DEFAULT_IN_MEMORY_PRIORITY_CRITICAL = 'CRITICAL'¶
A constant which can be used with the default_in_memory_priority property of a Tablespace. This constant has a value of “CRITICAL”
- DEFAULT_IN_MEMORY_PRIORITY_HIGH = 'HIGH'¶
A constant which can be used with the default_in_memory_priority property of a Tablespace. This constant has a value of “HIGH”
- DEFAULT_IN_MEMORY_PRIORITY_LOW = 'LOW'¶
A constant which can be used with the default_in_memory_priority property of a Tablespace. This constant has a value of “LOW”
- DEFAULT_IN_MEMORY_PRIORITY_MEDIUM = 'MEDIUM'¶
A constant which can be used with the default_in_memory_priority property of a Tablespace. This constant has a value of “MEDIUM”
- DEFAULT_IN_MEMORY_PRIORITY_NONE = 'NONE'¶
A constant which can be used with the default_in_memory_priority property of a Tablespace. This constant has a value of “NONE”
- DEFAULT_IN_MEMORY_SERVICE_ALL = 'ALL'¶
A constant which can be used with the default_in_memory_service property of a Tablespace. This constant has a value of “ALL”
- DEFAULT_IN_MEMORY_SERVICE_DEFAULT = 'DEFAULT'¶
A constant which can be used with the default_in_memory_service property of a Tablespace. This constant has a value of “DEFAULT”
- DEFAULT_IN_MEMORY_SERVICE_NONE = 'NONE'¶
A constant which can be used with the default_in_memory_service property of a Tablespace. This constant has a value of “NONE”
- DEFAULT_IN_MEMORY_SERVICE_USER_DEFINED = 'USER_DEFINED'¶
A constant which can be used with the default_in_memory_service property of a Tablespace. This constant has a value of “USER_DEFINED”
- DEFAULT_TABLE_COMPRESSION_DISABLED = 'DISABLED'¶
A constant which can be used with the default_table_compression property of a Tablespace. This constant has a value of “DISABLED”
- DEFAULT_TABLE_COMPRESSION_ENABLED = 'ENABLED'¶
A constant which can be used with the default_table_compression property of a Tablespace. This constant has a value of “ENABLED”
- EXTENT_MANAGEMENT_DICTIONARY = 'DICTIONARY'¶
A constant which can be used with the extent_management property of a Tablespace. This constant has a value of “DICTIONARY”
- EXTENT_MANAGEMENT_LOCAL = 'LOCAL'¶
A constant which can be used with the extent_management property of a Tablespace. This constant has a value of “LOCAL”
- INDEX_COMPRESS_FOR_ADVANCED_HIGH = 'ADVANCED_HIGH'¶
A constant which can be used with the index_compress_for property of a Tablespace. This constant has a value of “ADVANCED_HIGH”
- INDEX_COMPRESS_FOR_ADVANCED_LOW = 'ADVANCED_LOW'¶
A constant which can be used with the index_compress_for property of a Tablespace. This constant has a value of “ADVANCED_LOW”
- INDEX_COMPRESS_FOR_NONE = 'NONE'¶
A constant which can be used with the index_compress_for property of a Tablespace. This constant has a value of “NONE”
- LOGGING_LOGGING = 'LOGGING'¶
A constant which can be used with the logging property of a Tablespace. This constant has a value of “LOGGING”
- LOGGING_NOLOGGING = 'NOLOGGING'¶
A constant which can be used with the logging property of a Tablespace. This constant has a value of “NOLOGGING”
- LOST_WRITE_PROTECT_ENABLED = 'ENABLED'¶
A constant which can be used with the lost_write_protect property of a Tablespace. This constant has a value of “ENABLED”
- LOST_WRITE_PROTECT_PROTECT_OFF = 'PROTECT_OFF'¶
A constant which can be used with the lost_write_protect property of a Tablespace. This constant has a value of “PROTECT_OFF”
- LOST_WRITE_PROTECT_SUSPEND = 'SUSPEND'¶
A constant which can be used with the lost_write_protect property of a Tablespace. This constant has a value of “SUSPEND”
- PREDICATE_EVALUATION_HOST = 'HOST'¶
A constant which can be used with the predicate_evaluation property of a Tablespace. This constant has a value of “HOST”
- PREDICATE_EVALUATION_STORAGE = 'STORAGE'¶
A constant which can be used with the predicate_evaluation property of a Tablespace. This constant has a value of “STORAGE”
- RETENTION_GUARANTEE = 'GUARANTEE'¶
A constant which can be used with the retention property of a Tablespace. This constant has a value of “GUARANTEE”
- RETENTION_NOGUARANTEE = 'NOGUARANTEE'¶
A constant which can be used with the retention property of a Tablespace. This constant has a value of “NOGUARANTEE”
- RETENTION_NOT_APPLY = 'NOT_APPLY'¶
A constant which can be used with the retention property of a Tablespace. This constant has a value of “NOT_APPLY”
- SEGMENT_SPACE_MANAGEMENT_AUTO = 'AUTO'¶
A constant which can be used with the segment_space_management property of a Tablespace. This constant has a value of “AUTO”
- SEGMENT_SPACE_MANAGEMENT_MANUAL = 'MANUAL'¶
A constant which can be used with the segment_space_management property of a Tablespace. This constant has a value of “MANUAL”
- SHARED_LOCAL_ON_ALL = 'LOCAL_ON_ALL'¶
A constant which can be used with the shared property of a Tablespace. This constant has a value of “LOCAL_ON_ALL”
- SHARED_LOCAL_ON_LEAF = 'LOCAL_ON_LEAF'¶
A constant which can be used with the shared property of a Tablespace. This constant has a value of “LOCAL_ON_LEAF”
- SHARED_SHARED = 'SHARED'¶
A constant which can be used with the shared property of a Tablespace. This constant has a value of “SHARED”
- STATUS_OFFLINE = 'OFFLINE'¶
A constant which can be used with the status property of a Tablespace. This constant has a value of “OFFLINE”
- STATUS_ONLINE = 'ONLINE'¶
A constant which can be used with the status property of a Tablespace. This constant has a value of “ONLINE”
- STATUS_READ_ONLY = 'READ_ONLY'¶
A constant which can be used with the status property of a Tablespace. This constant has a value of “READ_ONLY”
- TYPE_LOST_WRITE_PROTECTION = 'LOST_WRITE_PROTECTION'¶
A constant which can be used with the type property of a Tablespace. This constant has a value of “LOST_WRITE_PROTECTION”
- TYPE_PERMANENT = 'PERMANENT'¶
A constant which can be used with the type property of a Tablespace. This constant has a value of “PERMANENT”
- TYPE_TEMPORARY = 'TEMPORARY'¶
A constant which can be used with the type property of a Tablespace. This constant has a value of “TEMPORARY”
- TYPE_UNDO = 'UNDO'¶
A constant which can be used with the type property of a Tablespace. This constant has a value of “UNDO”
- __init__(**kwargs)¶
Initializes a new Tablespace object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
name (str) – The value to assign to the name property of this Tablespace.
type (str) – The value to assign to the type property of this Tablespace. Allowed values for this property are: “UNDO”, “LOST_WRITE_PROTECTION”, “PERMANENT”, “TEMPORARY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
status (str) – The value to assign to the status property of this Tablespace. Allowed values for this property are: “ONLINE”, “OFFLINE”, “READ_ONLY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
block_size_bytes (float) – The value to assign to the block_size_bytes property of this Tablespace.
logging (str) – The value to assign to the logging property of this Tablespace. Allowed values for this property are: “LOGGING”, “NOLOGGING”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_force_logging (bool) – The value to assign to the is_force_logging property of this Tablespace.
extent_management (str) – The value to assign to the extent_management property of this Tablespace. Allowed values for this property are: “LOCAL”, “DICTIONARY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
allocation_type (str) – The value to assign to the allocation_type property of this Tablespace. Allowed values for this property are: “SYSTEM”, “UNIFORM”, “USER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_plugged_in (bool) – The value to assign to the is_plugged_in property of this Tablespace.
segment_space_management (str) – The value to assign to the segment_space_management property of this Tablespace. Allowed values for this property are: “MANUAL”, “AUTO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_table_compression (str) – The value to assign to the default_table_compression property of this Tablespace. Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
retention (str) – The value to assign to the retention property of this Tablespace. Allowed values for this property are: “GUARANTEE”, “NOGUARANTEE”, “NOT_APPLY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_bigfile (bool) – The value to assign to the is_bigfile property of this Tablespace.
predicate_evaluation (str) – The value to assign to the predicate_evaluation property of this Tablespace. Allowed values for this property are: “HOST”, “STORAGE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_encrypted (bool) – The value to assign to the is_encrypted property of this Tablespace.
compress_for (str) – The value to assign to the compress_for property of this Tablespace. Allowed values for this property are: “BASIC”, “ADVANCED”, “QUERY_LOW”, “QUERY_HIGH”, “ARCHIVE_LOW”, “ARCHIVE_HIGH”, “DIRECT_LOAD_ONLY”, “FOR_ALL_OPERATIONS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory (str) – The value to assign to the default_in_memory property of this Tablespace. Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory_priority (str) – The value to assign to the default_in_memory_priority property of this Tablespace. Allowed values for this property are: “LOW”, “MEDIUM”, “HIGH”, “CRITICAL”, “NONE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory_distribute (str) – The value to assign to the default_in_memory_distribute property of this Tablespace. Allowed values for this property are: “AUTO”, “BY_ROWID_RANGE”, “BY_PARTITION”, “BY_SUBPARTITION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory_compression (str) – The value to assign to the default_in_memory_compression property of this Tablespace. Allowed values for this property are: “NO_MEMCOMPRESS”, “FOR_DML”, “FOR_QUERY_LOW”, “FOR_QUERY_HIGH”, “FOR_CAPACITY_LOW”, “FOR_CAPACITY_HIGH”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory_duplicate (str) – The value to assign to the default_in_memory_duplicate property of this Tablespace. Allowed values for this property are: “NO_DUPLICATE”, “DUPLICATE”, “DUPLICATE_ALL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
shared (str) – The value to assign to the shared property of this Tablespace. Allowed values for this property are: “SHARED”, “LOCAL_ON_LEAF”, “LOCAL_ON_ALL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_index_compression (str) – The value to assign to the default_index_compression property of this Tablespace. Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
index_compress_for (str) – The value to assign to the index_compress_for property of this Tablespace. Allowed values for this property are: “ADVANCED_LOW”, “ADVANCED_HIGH”, “NONE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_cell_memory (str) – The value to assign to the default_cell_memory property of this Tablespace.
default_in_memory_service (str) – The value to assign to the default_in_memory_service property of this Tablespace. Allowed values for this property are: “DEFAULT”, “NONE”, “ALL”, “USER_DEFINED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
default_in_memory_service_name (str) – The value to assign to the default_in_memory_service_name property of this Tablespace.
lost_write_protect (str) – The value to assign to the lost_write_protect property of this Tablespace. Allowed values for this property are: “ENABLED”, “PROTECT_OFF”, “SUSPEND”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_chunk_tablespace (bool) – The value to assign to the is_chunk_tablespace property of this Tablespace.
temp_group (str) – The value to assign to the temp_group property of this Tablespace.
max_size_kb (float) – The value to assign to the max_size_kb property of this Tablespace.
allocated_size_kb (float) – The value to assign to the allocated_size_kb property of this Tablespace.
user_size_kb (float) – The value to assign to the user_size_kb property of this Tablespace.
free_space_kb (float) – The value to assign to the free_space_kb property of this Tablespace.
used_space_kb (float) – The value to assign to the used_space_kb property of this Tablespace.
used_percent_available (float) – The value to assign to the used_percent_available property of this Tablespace.
used_percent_allocated (float) – The value to assign to the used_percent_allocated property of this Tablespace.
is_default (bool) – The value to assign to the is_default property of this Tablespace.
datafiles (list[oci.database_management.models.Datafile]) – The value to assign to the datafiles property of this Tablespace.
- property allocated_size_kb¶
Gets the allocated_size_kb of this Tablespace. The allocated tablespace size in KB.
- Returns
The allocated_size_kb of this Tablespace.
- Return type
float
- property allocation_type¶
Gets the allocation_type of this Tablespace. The type of extent allocation in effect for the tablespace.
Allowed values for this property are: “SYSTEM”, “UNIFORM”, “USER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The allocation_type of this Tablespace.
- Return type
str
- property block_size_bytes¶
Gets the block_size_bytes of this Tablespace. The tablespace block size.
- Returns
The block_size_bytes of this Tablespace.
- Return type
float
- property compress_for¶
Gets the compress_for of this Tablespace. The operation type for which default compression is enabled.
Allowed values for this property are: “BASIC”, “ADVANCED”, “QUERY_LOW”, “QUERY_HIGH”, “ARCHIVE_LOW”, “ARCHIVE_HIGH”, “DIRECT_LOAD_ONLY”, “FOR_ALL_OPERATIONS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The compress_for of this Tablespace.
- Return type
str
- property datafiles¶
Gets the datafiles of this Tablespace. A list of the data files associated with the tablespace.
- Returns
The datafiles of this Tablespace.
- Return type
- property default_cell_memory¶
Gets the default_cell_memory of this Tablespace. This specifies the default value for the CELLMEMORY attribute that tables created in the tablespace will inherit unless the behavior is overridden explicitly. This column is intended for use with Oracle Exadata.
- Returns
The default_cell_memory of this Tablespace.
- Return type
str
- property default_in_memory¶
Gets the default_in_memory of this Tablespace. Indicates whether the In-Memory Column Store (IM column store) is by default enabled or disabled for tables in the tablespace.
Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory of this Tablespace.
- Return type
str
- property default_in_memory_compression¶
Gets the default_in_memory_compression of this Tablespace. Indicates the default compression level for the IM column store for the tablespace.
Allowed values for this property are: “NO_MEMCOMPRESS”, “FOR_DML”, “FOR_QUERY_LOW”, “FOR_QUERY_HIGH”, “FOR_CAPACITY_LOW”, “FOR_CAPACITY_HIGH”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory_compression of this Tablespace.
- Return type
str
- property default_in_memory_distribute¶
Gets the default_in_memory_distribute of this Tablespace. Indicates how the IM column store is distributed by default for the tablespace in an Oracle Real Application Clusters (Oracle RAC) environment.
Allowed values for this property are: “AUTO”, “BY_ROWID_RANGE”, “BY_PARTITION”, “BY_SUBPARTITION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory_distribute of this Tablespace.
- Return type
str
- property default_in_memory_duplicate¶
Gets the default_in_memory_duplicate of this Tablespace. Indicates the duplicate setting for the IM column store in an Oracle RAC environment.
Allowed values for this property are: “NO_DUPLICATE”, “DUPLICATE”, “DUPLICATE_ALL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory_duplicate of this Tablespace.
- Return type
str
- property default_in_memory_priority¶
Gets the default_in_memory_priority of this Tablespace. Indicates the default priority for In-Memory Column Store (IM column store) population for the tablespace.
Allowed values for this property are: “LOW”, “MEDIUM”, “HIGH”, “CRITICAL”, “NONE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory_priority of this Tablespace.
- Return type
str
- property default_in_memory_service¶
Gets the default_in_memory_service of this Tablespace. Indicates how the IM column store is populated on various instances by default for the tablespace.
Allowed values for this property are: “DEFAULT”, “NONE”, “ALL”, “USER_DEFINED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_in_memory_service of this Tablespace.
- Return type
str
- property default_in_memory_service_name¶
Gets the default_in_memory_service_name of this Tablespace. Indicates the service name for the service on which the IM column store should be populated by default for the tablespace. This column has a value only when the corresponding DEF_INMEMORY_SERVICE is USER_DEFINED. In all other cases, this column is null.
- Returns
The default_in_memory_service_name of this Tablespace.
- Return type
str
- property default_index_compression¶
Gets the default_index_compression of this Tablespace. Indicates whether default index compression is enabled or disabled.
Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_index_compression of this Tablespace.
- Return type
str
- property default_table_compression¶
Gets the default_table_compression of this Tablespace. Indicates whether default table compression is enabled or disabled.
Allowed values for this property are: “ENABLED”, “DISABLED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The default_table_compression of this Tablespace.
- Return type
str
- property extent_management¶
Gets the extent_management of this Tablespace. Indicates whether the extents in the tablespace are Locally managed or Dictionary managed.
Allowed values for this property are: “LOCAL”, “DICTIONARY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The extent_management of this Tablespace.
- Return type
str
- property free_space_kb¶
Gets the free_space_kb of this Tablespace. The free space available in the tablespace in KB.
- Returns
The free_space_kb of this Tablespace.
- Return type
float
- property index_compress_for¶
Gets the index_compress_for of this Tablespace. The operation type for which default index compression is enabled.
Allowed values for this property are: “ADVANCED_LOW”, “ADVANCED_HIGH”, “NONE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The index_compress_for of this Tablespace.
- Return type
str
- property is_bigfile¶
Gets the is_bigfile of this Tablespace. Indicates whether the tablespace is a Bigfile tablespace or a Smallfile tablespace.
- Returns
The is_bigfile of this Tablespace.
- Return type
bool
- property is_chunk_tablespace¶
Gets the is_chunk_tablespace of this Tablespace. Indicates whether this is a chunk tablespace.
- Returns
The is_chunk_tablespace of this Tablespace.
- Return type
bool
- property is_default¶
Gets the is_default of this Tablespace. Indicates whether this is the default tablespace.
- Returns
The is_default of this Tablespace.
- Return type
bool
- property is_encrypted¶
Gets the is_encrypted of this Tablespace. Indicates whether the tablespace is encrypted.
- Returns
The is_encrypted of this Tablespace.
- Return type
bool
- property is_force_logging¶
Gets the is_force_logging of this Tablespace. Indicates whether the tablespace is under Force Logging mode.
- Returns
The is_force_logging of this Tablespace.
- Return type
bool
- property is_plugged_in¶
Gets the is_plugged_in of this Tablespace. Indicates whether the tablespace is plugged in.
- Returns
The is_plugged_in of this Tablespace.
- Return type
bool
- property logging¶
Gets the logging of this Tablespace. The default logging attribute.
Allowed values for this property are: “LOGGING”, “NOLOGGING”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The logging of this Tablespace.
- Return type
str
- property lost_write_protect¶
Gets the lost_write_protect of this Tablespace. The lost write protection setting for the tablespace.
Allowed values for this property are: “ENABLED”, “PROTECT_OFF”, “SUSPEND”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The lost_write_protect of this Tablespace.
- Return type
str
- property max_size_kb¶
Gets the max_size_kb of this Tablespace. The maximum tablespace size in KB. If the tablespace contains any data files with Autoextend enabled, then this column displays the amount of underlying free storage space for the tablespace. For example, if the current tablespace size is 1 GB, the combined maximum size of all its data files is 32 GB, and its underlying storage (for example, ASM or file system storage) has 20 GB of free space, then this column will have a value of approximately 20 GB. If the tablespace contains only data files with autoextend disabled, then this column displays the allocated space for the entire tablespace, that is, the combined size of all data files in the tablespace.
- Returns
The max_size_kb of this Tablespace.
- Return type
float
- property name¶
[Required] Gets the name of this Tablespace. The name of the tablespace.
- Returns
The name of this Tablespace.
- Return type
str
- property predicate_evaluation¶
Gets the predicate_evaluation of this Tablespace. Indicates whether predicates are evaluated by Host or by Storage.
Allowed values for this property are: “HOST”, “STORAGE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The predicate_evaluation of this Tablespace.
- Return type
str
- property retention¶
Gets the retention of this Tablespace. Indicates whether undo retention guarantee is enabled for the tablespace.
Allowed values for this property are: “GUARANTEE”, “NOGUARANTEE”, “NOT_APPLY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The retention of this Tablespace.
- Return type
str
- property segment_space_management¶
Gets the segment_space_management of this Tablespace. Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO).
Allowed values for this property are: “MANUAL”, “AUTO”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The segment_space_management of this Tablespace.
- Return type
str
Gets the shared of this Tablespace. Indicates whether the tablespace is for shared tablespace, or for local temporary tablespace for leaf (read-only) instances, or for local temporary tablespace for all instance types.
Allowed values for this property are: “SHARED”, “LOCAL_ON_LEAF”, “LOCAL_ON_ALL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The shared of this Tablespace.
- Return type
str
- property status¶
Gets the status of this Tablespace. The status of the tablespace.
Allowed values for this property are: “ONLINE”, “OFFLINE”, “READ_ONLY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The status of this Tablespace.
- Return type
str
- property temp_group¶
Gets the temp_group of this Tablespace. The temporary tablespace group.
- Returns
The temp_group of this Tablespace.
- Return type
str
- property type¶
[Required] Gets the type of this Tablespace. The type of tablespace.
Allowed values for this property are: “UNDO”, “LOST_WRITE_PROTECTION”, “PERMANENT”, “TEMPORARY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The type of this Tablespace.
- Return type
str
- property used_percent_allocated¶
Gets the used_percent_allocated of this Tablespace. The percentage of used space out of the total allocated space in the tablespace.
- Returns
The used_percent_allocated of this Tablespace.
- Return type
float
- property used_percent_available¶
Gets the used_percent_available of this Tablespace. The percentage of used space out of the maximum available space in the tablespace.
- Returns
The used_percent_available of this Tablespace.
- Return type
float
- property used_space_kb¶
Gets the used_space_kb of this Tablespace. The total space used by the tablespace in KB.
- Returns
The used_space_kb of this Tablespace.
- Return type
float
- property user_size_kb¶
Gets the user_size_kb of this Tablespace. The size of the tablespace available for user data in KB. The difference between tablespace size and user data size is used for storing metadata.
- Returns
The user_size_kb of this Tablespace.
- Return type
float