Tablespace¶
-
class
oci.database_management.models.Tablespace(**kwargs)¶ Bases:
objectThe details of a tablespace.
Attributes
ALLOCATION_TYPE_SYSTEMA constant which can be used with the allocation_type property of a Tablespace. ALLOCATION_TYPE_UNIFORMA constant which can be used with the allocation_type property of a Tablespace. ALLOCATION_TYPE_USERA constant which can be used with the allocation_type property of a Tablespace. COMPRESS_FOR_ADVANCEDA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_ARCHIVE_HIGHA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_ARCHIVE_LOWA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_BASICA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_DIRECT_LOAD_ONLYA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_FOR_ALL_OPERATIONSA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_QUERY_HIGHA constant which can be used with the compress_for property of a Tablespace. COMPRESS_FOR_QUERY_LOWA constant which can be used with the compress_for property of a Tablespace. DEFAULT_INDEX_COMPRESSION_DISABLEDA constant which can be used with the default_index_compression property of a Tablespace. DEFAULT_INDEX_COMPRESSION_ENABLEDA constant which can be used with the default_index_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_HIGHA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_LOWA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_FOR_DMLA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_HIGHA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_LOWA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_COMPRESSION_NO_MEMCOMPRESSA constant which can be used with the default_in_memory_compression property of a Tablespace. DEFAULT_IN_MEMORY_DISABLEDA constant which can be used with the default_in_memory property of a Tablespace. DEFAULT_IN_MEMORY_DISTRIBUTE_AUTOA constant which can be used with the default_in_memory_distribute property of a Tablespace. DEFAULT_IN_MEMORY_DISTRIBUTE_BY_PARTITIONA constant which can be used with the default_in_memory_distribute property of a Tablespace. DEFAULT_IN_MEMORY_DISTRIBUTE_BY_ROWID_RANGEA constant which can be used with the default_in_memory_distribute property of a Tablespace. DEFAULT_IN_MEMORY_DISTRIBUTE_BY_SUBPARTITIONA constant which can be used with the default_in_memory_distribute property of a Tablespace. DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATEA constant which can be used with the default_in_memory_duplicate property of a Tablespace. DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATE_ALLA constant which can be used with the default_in_memory_duplicate property of a Tablespace. DEFAULT_IN_MEMORY_DUPLICATE_NO_DUPLICATEA constant which can be used with the default_in_memory_duplicate property of a Tablespace. DEFAULT_IN_MEMORY_ENABLEDA constant which can be used with the default_in_memory property of a Tablespace. DEFAULT_IN_MEMORY_PRIORITY_CRITICALA constant which can be used with the default_in_memory_priority property of a Tablespace. DEFAULT_IN_MEMORY_PRIORITY_HIGHA constant which can be used with the default_in_memory_priority property of a Tablespace. DEFAULT_IN_MEMORY_PRIORITY_LOWA constant which can be used with the default_in_memory_priority property of a Tablespace. DEFAULT_IN_MEMORY_PRIORITY_MEDIUMA constant which can be used with the default_in_memory_priority property of a Tablespace. DEFAULT_IN_MEMORY_PRIORITY_NONEA constant which can be used with the default_in_memory_priority property of a Tablespace. DEFAULT_IN_MEMORY_SERVICE_ALLA constant which can be used with the default_in_memory_service property of a Tablespace. DEFAULT_IN_MEMORY_SERVICE_DEFAULTA constant which can be used with the default_in_memory_service property of a Tablespace. DEFAULT_IN_MEMORY_SERVICE_NONEA constant which can be used with the default_in_memory_service property of a Tablespace. DEFAULT_IN_MEMORY_SERVICE_USER_DEFINEDA constant which can be used with the default_in_memory_service property of a Tablespace. DEFAULT_TABLE_COMPRESSION_DISABLEDA constant which can be used with the default_table_compression property of a Tablespace. DEFAULT_TABLE_COMPRESSION_ENABLEDA constant which can be used with the default_table_compression property of a Tablespace. EXTENT_MANAGEMENT_DICTIONARYA constant which can be used with the extent_management property of a Tablespace. EXTENT_MANAGEMENT_LOCALA constant which can be used with the extent_management property of a Tablespace. INDEX_COMPRESS_FOR_ADVANCED_HIGHA constant which can be used with the index_compress_for property of a Tablespace. INDEX_COMPRESS_FOR_ADVANCED_LOWA constant which can be used with the index_compress_for property of a Tablespace. INDEX_COMPRESS_FOR_NONEA constant which can be used with the index_compress_for property of a Tablespace. LOGGING_LOGGINGA constant which can be used with the logging property of a Tablespace. LOGGING_NOLOGGINGA constant which can be used with the logging property of a Tablespace. LOST_WRITE_PROTECT_ENABLEDA constant which can be used with the lost_write_protect property of a Tablespace. LOST_WRITE_PROTECT_PROTECT_OFFA constant which can be used with the lost_write_protect property of a Tablespace. LOST_WRITE_PROTECT_SUSPENDA constant which can be used with the lost_write_protect property of a Tablespace. PREDICATE_EVALUATION_HOSTA constant which can be used with the predicate_evaluation property of a Tablespace. PREDICATE_EVALUATION_STORAGEA constant which can be used with the predicate_evaluation property of a Tablespace. RETENTION_GUARANTEEA constant which can be used with the retention property of a Tablespace. RETENTION_NOGUARANTEEA constant which can be used with the retention property of a Tablespace. RETENTION_NOT_APPLYA constant which can be used with the retention property of a Tablespace. SEGMENT_SPACE_MANAGEMENT_AUTOA constant which can be used with the segment_space_management property of a Tablespace. SEGMENT_SPACE_MANAGEMENT_MANUALA constant which can be used with the segment_space_management property of a Tablespace. SHARED_LOCAL_ON_ALLA constant which can be used with the shared property of a Tablespace. SHARED_LOCAL_ON_LEAFA constant which can be used with the shared property of a Tablespace. SHARED_SHAREDA constant which can be used with the shared property of a Tablespace. STATUS_OFFLINEA constant which can be used with the status property of a Tablespace. STATUS_ONLINEA constant which can be used with the status property of a Tablespace. STATUS_READ_ONLYA constant which can be used with the status property of a Tablespace. TYPE_LOST_WRITE_PROTECTIONA constant which can be used with the type property of a Tablespace. TYPE_PERMANENTA constant which can be used with the type property of a Tablespace. TYPE_TEMPORARYA constant which can be used with the type property of a Tablespace. TYPE_UNDOA constant which can be used with the type property of a Tablespace. allocated_size_kbGets the allocated_size_kb of this Tablespace. allocation_typeGets the allocation_type of this Tablespace. block_size_bytesGets the block_size_bytes of this Tablespace. compress_forGets the compress_for of this Tablespace. datafilesGets the datafiles of this Tablespace. default_cell_memoryGets the default_cell_memory of this Tablespace. default_in_memoryGets the default_in_memory of this Tablespace. default_in_memory_compressionGets the default_in_memory_compression of this Tablespace. default_in_memory_distributeGets the default_in_memory_distribute of this Tablespace. default_in_memory_duplicateGets the default_in_memory_duplicate of this Tablespace. default_in_memory_priorityGets the default_in_memory_priority of this Tablespace. default_in_memory_serviceGets the default_in_memory_service of this Tablespace. default_in_memory_service_nameGets the default_in_memory_service_name of this Tablespace. default_index_compressionGets the default_index_compression of this Tablespace. default_table_compressionGets the default_table_compression of this Tablespace. extent_managementGets the extent_management of this Tablespace. free_space_kbGets the free_space_kb of this Tablespace. index_compress_forGets the index_compress_for of this Tablespace. is_bigfileGets the is_bigfile of this Tablespace. is_chunk_tablespaceGets the is_chunk_tablespace of this Tablespace. is_defaultGets the is_default of this Tablespace. is_encryptedGets the is_encrypted of this Tablespace. is_force_loggingGets the is_force_logging of this Tablespace. is_plugged_inGets the is_plugged_in of this Tablespace. loggingGets the logging of this Tablespace. lost_write_protectGets the lost_write_protect of this Tablespace. max_size_kbGets the max_size_kb of this Tablespace. name[Required] Gets the name of this Tablespace. predicate_evaluationGets the predicate_evaluation of this Tablespace. retentionGets the retention of this Tablespace. segment_space_managementGets the segment_space_management of this Tablespace. sharedGets the shared of this Tablespace. statusGets the status of this Tablespace. temp_groupGets the temp_group of this Tablespace. type[Required] Gets the type of this Tablespace. used_percent_allocatedGets the used_percent_allocated of this Tablespace. used_percent_availableGets the used_percent_available of this Tablespace. used_space_kbGets the used_space_kb of this Tablespace. user_size_kbGets 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.
-
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
-
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
-
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
-
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
-
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: list[oci.database_management.models.Datafile]
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
name¶ [Required] Gets the name of this Tablespace. The name of the tablespace.
Returns: The name of this Tablespace. Return type: str
-
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
-
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
-
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
-
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
-
temp_group¶ Gets the temp_group of this Tablespace. The temporary tablespace group.
Returns: The temp_group of this Tablespace. Return type: str
-
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
-
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
-
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
-
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
-
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
-