Tablespace

class oci.database_management.models.Tablespace(**kwargs)

Bases: object

The details of a tablespace.

Attributes:

ALLOCATION_TYPE_SYSTEM

A constant which can be used with the allocation_type property of a Tablespace.

ALLOCATION_TYPE_UNIFORM

A constant which can be used with the allocation_type property of a Tablespace.

ALLOCATION_TYPE_USER

A constant which can be used with the allocation_type property of a Tablespace.

COMPRESS_FOR_ADVANCED

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_ARCHIVE_HIGH

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_ARCHIVE_LOW

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_BASIC

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_DIRECT_LOAD_ONLY

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_FOR_ALL_OPERATIONS

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_QUERY_HIGH

A constant which can be used with the compress_for property of a Tablespace.

COMPRESS_FOR_QUERY_LOW

A constant which can be used with the compress_for property of a Tablespace.

DEFAULT_INDEX_COMPRESSION_DISABLED

A constant which can be used with the default_index_compression property of a Tablespace.

DEFAULT_INDEX_COMPRESSION_ENABLED

A constant which can be used with the default_index_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_HIGH

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_FOR_CAPACITY_LOW

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_FOR_DML

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_HIGH

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_FOR_QUERY_LOW

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_COMPRESSION_NO_MEMCOMPRESS

A constant which can be used with the default_in_memory_compression property of a Tablespace.

DEFAULT_IN_MEMORY_DISABLED

A constant which can be used with the default_in_memory property of a Tablespace.

DEFAULT_IN_MEMORY_DISTRIBUTE_AUTO

A constant which can be used with the default_in_memory_distribute property of a Tablespace.

DEFAULT_IN_MEMORY_DISTRIBUTE_BY_PARTITION

A constant which can be used with the default_in_memory_distribute property of a Tablespace.

DEFAULT_IN_MEMORY_DISTRIBUTE_BY_ROWID_RANGE

A constant which can be used with the default_in_memory_distribute property of a Tablespace.

DEFAULT_IN_MEMORY_DISTRIBUTE_BY_SUBPARTITION

A constant which can be used with the default_in_memory_distribute property of a Tablespace.

DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATE

A constant which can be used with the default_in_memory_duplicate property of a Tablespace.

DEFAULT_IN_MEMORY_DUPLICATE_DUPLICATE_ALL

A constant which can be used with the default_in_memory_duplicate property of a Tablespace.

DEFAULT_IN_MEMORY_DUPLICATE_NO_DUPLICATE

A constant which can be used with the default_in_memory_duplicate property of a Tablespace.

DEFAULT_IN_MEMORY_ENABLED

A constant which can be used with the default_in_memory property of a Tablespace.

DEFAULT_IN_MEMORY_PRIORITY_CRITICAL

A constant which can be used with the default_in_memory_priority property of a Tablespace.

DEFAULT_IN_MEMORY_PRIORITY_HIGH

A constant which can be used with the default_in_memory_priority property of a Tablespace.

DEFAULT_IN_MEMORY_PRIORITY_LOW

A constant which can be used with the default_in_memory_priority property of a Tablespace.

DEFAULT_IN_MEMORY_PRIORITY_MEDIUM

A constant which can be used with the default_in_memory_priority property of a Tablespace.

DEFAULT_IN_MEMORY_PRIORITY_NONE

A constant which can be used with the default_in_memory_priority property of a Tablespace.

DEFAULT_IN_MEMORY_SERVICE_ALL

A constant which can be used with the default_in_memory_service property of a Tablespace.

DEFAULT_IN_MEMORY_SERVICE_DEFAULT

A constant which can be used with the default_in_memory_service property of a Tablespace.

DEFAULT_IN_MEMORY_SERVICE_NONE

A constant which can be used with the default_in_memory_service property of a Tablespace.

DEFAULT_IN_MEMORY_SERVICE_USER_DEFINED

A constant which can be used with the default_in_memory_service property of a Tablespace.

DEFAULT_TABLE_COMPRESSION_DISABLED

A constant which can be used with the default_table_compression property of a Tablespace.

DEFAULT_TABLE_COMPRESSION_ENABLED

A constant which can be used with the default_table_compression property of a Tablespace.

EXTENT_MANAGEMENT_DICTIONARY

A constant which can be used with the extent_management property of a Tablespace.

EXTENT_MANAGEMENT_LOCAL

A constant which can be used with the extent_management property of a Tablespace.

INDEX_COMPRESS_FOR_ADVANCED_HIGH

A constant which can be used with the index_compress_for property of a Tablespace.

INDEX_COMPRESS_FOR_ADVANCED_LOW

A constant which can be used with the index_compress_for property of a Tablespace.

INDEX_COMPRESS_FOR_NONE

A constant which can be used with the index_compress_for property of a Tablespace.

LOGGING_LOGGING

A constant which can be used with the logging property of a Tablespace.

LOGGING_NOLOGGING

A constant which can be used with the logging property of a Tablespace.

LOST_WRITE_PROTECT_ENABLED

A constant which can be used with the lost_write_protect property of a Tablespace.

LOST_WRITE_PROTECT_PROTECT_OFF

A constant which can be used with the lost_write_protect property of a Tablespace.

LOST_WRITE_PROTECT_SUSPEND

A constant which can be used with the lost_write_protect property of a Tablespace.

PREDICATE_EVALUATION_HOST

A constant which can be used with the predicate_evaluation property of a Tablespace.

PREDICATE_EVALUATION_STORAGE

A constant which can be used with the predicate_evaluation property of a Tablespace.

RETENTION_GUARANTEE

A constant which can be used with the retention property of a Tablespace.

RETENTION_NOGUARANTEE

A constant which can be used with the retention property of a Tablespace.

RETENTION_NOT_APPLY

A constant which can be used with the retention property of a Tablespace.

SEGMENT_SPACE_MANAGEMENT_AUTO

A constant which can be used with the segment_space_management property of a Tablespace.

SEGMENT_SPACE_MANAGEMENT_MANUAL

A constant which can be used with the segment_space_management property of a Tablespace.

SHARED_LOCAL_ON_ALL

A constant which can be used with the shared property of a Tablespace.

SHARED_LOCAL_ON_LEAF

A constant which can be used with the shared property of a Tablespace.

SHARED_SHARED

A constant which can be used with the shared property of a Tablespace.

STATUS_OFFLINE

A constant which can be used with the status property of a Tablespace.

STATUS_ONLINE

A constant which can be used with the status property of a Tablespace.

STATUS_READ_ONLY

A constant which can be used with the status property of a Tablespace.

TYPE_LOST_WRITE_PROTECTION

A constant which can be used with the type property of a Tablespace.

TYPE_PERMANENT

A constant which can be used with the type property of a Tablespace.

TYPE_TEMPORARY

A constant which can be used with the type property of a Tablespace.

TYPE_UNDO

A constant which can be used with the type property of a Tablespace.

allocated_size_kb

Gets the allocated_size_kb of this Tablespace.

allocation_type

Gets the allocation_type of this Tablespace.

block_size_bytes

Gets the block_size_bytes of this Tablespace.

compress_for

Gets the compress_for of this Tablespace.

datafiles

Gets the datafiles of this Tablespace.

default_cell_memory

Gets the default_cell_memory of this Tablespace.

default_in_memory

Gets the default_in_memory of this Tablespace.

default_in_memory_compression

Gets the default_in_memory_compression of this Tablespace.

default_in_memory_distribute

Gets the default_in_memory_distribute of this Tablespace.

default_in_memory_duplicate

Gets the default_in_memory_duplicate of this Tablespace.

default_in_memory_priority

Gets the default_in_memory_priority of this Tablespace.

default_in_memory_service

Gets the default_in_memory_service of this Tablespace.

default_in_memory_service_name

Gets the default_in_memory_service_name of this Tablespace.

default_index_compression

Gets the default_index_compression of this Tablespace.

default_table_compression

Gets the default_table_compression of this Tablespace.

extent_management

Gets the extent_management of this Tablespace.

free_space_kb

Gets the free_space_kb of this Tablespace.

index_compress_for

Gets the index_compress_for of this Tablespace.

is_bigfile

Gets the is_bigfile of this Tablespace.

is_chunk_tablespace

Gets the is_chunk_tablespace of this Tablespace.

is_default

Gets the is_default of this Tablespace.

is_encrypted

Gets the is_encrypted of this Tablespace.

is_force_logging

Gets the is_force_logging of this Tablespace.

is_plugged_in

Gets the is_plugged_in of this Tablespace.

logging

Gets the logging of this Tablespace.

lost_write_protect

Gets the lost_write_protect of this Tablespace.

max_size_kb

Gets the max_size_kb of this Tablespace.

name

[Required] Gets the name of this Tablespace.

predicate_evaluation

Gets the predicate_evaluation of this Tablespace.

retention

Gets the retention of this Tablespace.

segment_space_management

Gets the segment_space_management of this Tablespace.

shared

Gets the shared of this Tablespace.

status

Gets the status of this Tablespace.

temp_group

Gets the temp_group of this Tablespace.

type

[Required] Gets the type of this Tablespace.

used_percent_allocated

Gets the used_percent_allocated of this Tablespace.

used_percent_available

Gets the used_percent_available of this Tablespace.

used_space_kb

Gets the used_space_kb of this Tablespace.

user_size_kb

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

list[oci.database_management.models.Datafile]

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

property shared

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