CreateTablespaceDetails

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

Bases: object

The details required to create a tablespace. It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential

Attributes:

DEFAULT_COMPRESS_BASIC_COMPRESS

A constant which can be used with the default_compress property of a CreateTablespaceDetails.

DEFAULT_COMPRESS_NO_COMPRESS

A constant which can be used with the default_compress property of a CreateTablespaceDetails.

EXTENT_MANAGEMENT_AUTOALLOCATE

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

EXTENT_MANAGEMENT_UNIFORM

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

SEGMENT_MANAGEMENT_AUTO

A constant which can be used with the segment_management property of a CreateTablespaceDetails.

SEGMENT_MANAGEMENT_MANUAL

A constant which can be used with the segment_management property of a CreateTablespaceDetails.

STATUS_READ_ONLY

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

STATUS_READ_WRITE

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

TYPE_PERMANENT

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

TYPE_TEMPORARY

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

auto_extend_max_size

Gets the auto_extend_max_size of this CreateTablespaceDetails.

auto_extend_next_size

Gets the auto_extend_next_size of this CreateTablespaceDetails.

block_size_in_kilobytes

Gets the block_size_in_kilobytes of this CreateTablespaceDetails.

credential_details

Gets the credential_details of this CreateTablespaceDetails.

data_files

Gets the data_files of this CreateTablespaceDetails.

database_credential

Gets the database_credential of this CreateTablespaceDetails.

default_compress

Gets the default_compress of this CreateTablespaceDetails.

encryption_algorithm

Gets the encryption_algorithm of this CreateTablespaceDetails.

extent_management

Gets the extent_management of this CreateTablespaceDetails.

extent_uniform_size

Gets the extent_uniform_size of this CreateTablespaceDetails.

file_count

Gets the file_count of this CreateTablespaceDetails.

file_size

Gets the file_size of this CreateTablespaceDetails.

is_auto_extensible

Gets the is_auto_extensible of this CreateTablespaceDetails.

is_bigfile

Gets the is_bigfile of this CreateTablespaceDetails.

is_default

Gets the is_default of this CreateTablespaceDetails.

is_encrypted

Gets the is_encrypted of this CreateTablespaceDetails.

is_max_size_unlimited

Gets the is_max_size_unlimited of this CreateTablespaceDetails.

is_reusable

Gets the is_reusable of this CreateTablespaceDetails.

name

[Required] Gets the name of this CreateTablespaceDetails.

segment_management

Gets the segment_management of this CreateTablespaceDetails.

status

Gets the status of this CreateTablespaceDetails.

type

Gets the type of this CreateTablespaceDetails.

Methods:

__init__(**kwargs)

Initializes a new CreateTablespaceDetails object with values from keyword arguments.

DEFAULT_COMPRESS_BASIC_COMPRESS = 'BASIC_COMPRESS'

A constant which can be used with the default_compress property of a CreateTablespaceDetails. This constant has a value of “BASIC_COMPRESS”

DEFAULT_COMPRESS_NO_COMPRESS = 'NO_COMPRESS'

A constant which can be used with the default_compress property of a CreateTablespaceDetails. This constant has a value of “NO_COMPRESS”

EXTENT_MANAGEMENT_AUTOALLOCATE = 'AUTOALLOCATE'

A constant which can be used with the extent_management property of a CreateTablespaceDetails. This constant has a value of “AUTOALLOCATE”

EXTENT_MANAGEMENT_UNIFORM = 'UNIFORM'

A constant which can be used with the extent_management property of a CreateTablespaceDetails. This constant has a value of “UNIFORM”

SEGMENT_MANAGEMENT_AUTO = 'AUTO'

A constant which can be used with the segment_management property of a CreateTablespaceDetails. This constant has a value of “AUTO”

SEGMENT_MANAGEMENT_MANUAL = 'MANUAL'

A constant which can be used with the segment_management property of a CreateTablespaceDetails. This constant has a value of “MANUAL”

STATUS_READ_ONLY = 'READ_ONLY'

A constant which can be used with the status property of a CreateTablespaceDetails. This constant has a value of “READ_ONLY”

STATUS_READ_WRITE = 'READ_WRITE'

A constant which can be used with the status property of a CreateTablespaceDetails. This constant has a value of “READ_WRITE”

TYPE_PERMANENT = 'PERMANENT'

A constant which can be used with the type property of a CreateTablespaceDetails. This constant has a value of “PERMANENT”

TYPE_TEMPORARY = 'TEMPORARY'

A constant which can be used with the type property of a CreateTablespaceDetails. This constant has a value of “TEMPORARY”

__init__(**kwargs)

Initializes a new CreateTablespaceDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • credential_details (oci.database_management.models.TablespaceAdminCredentialDetails) – The value to assign to the credential_details property of this CreateTablespaceDetails.

  • database_credential (oci.database_management.models.DatabaseCredentialDetails) – The value to assign to the database_credential property of this CreateTablespaceDetails.

  • name (str) – The value to assign to the name property of this CreateTablespaceDetails.

  • type (str) – The value to assign to the type property of this CreateTablespaceDetails. Allowed values for this property are: “PERMANENT”, “TEMPORARY”

  • is_bigfile (bool) – The value to assign to the is_bigfile property of this CreateTablespaceDetails.

  • data_files (list[str]) – The value to assign to the data_files property of this CreateTablespaceDetails.

  • file_count (int) – The value to assign to the file_count property of this CreateTablespaceDetails.

  • file_size (oci.database_management.models.TablespaceStorageSize) – The value to assign to the file_size property of this CreateTablespaceDetails.

  • is_reusable (bool) – The value to assign to the is_reusable property of this CreateTablespaceDetails.

  • is_auto_extensible (bool) – The value to assign to the is_auto_extensible property of this CreateTablespaceDetails.

  • auto_extend_next_size (oci.database_management.models.TablespaceStorageSize) – The value to assign to the auto_extend_next_size property of this CreateTablespaceDetails.

  • auto_extend_max_size (oci.database_management.models.TablespaceStorageSize) – The value to assign to the auto_extend_max_size property of this CreateTablespaceDetails.

  • is_max_size_unlimited (bool) – The value to assign to the is_max_size_unlimited property of this CreateTablespaceDetails.

  • block_size_in_kilobytes (int) – The value to assign to the block_size_in_kilobytes property of this CreateTablespaceDetails.

  • is_encrypted (bool) – The value to assign to the is_encrypted property of this CreateTablespaceDetails.

  • encryption_algorithm (str) – The value to assign to the encryption_algorithm property of this CreateTablespaceDetails.

  • default_compress (str) – The value to assign to the default_compress property of this CreateTablespaceDetails. Allowed values for this property are: “NO_COMPRESS”, “BASIC_COMPRESS”

  • status (str) – The value to assign to the status property of this CreateTablespaceDetails. Allowed values for this property are: “READ_ONLY”, “READ_WRITE”

  • extent_management (str) – The value to assign to the extent_management property of this CreateTablespaceDetails. Allowed values for this property are: “AUTOALLOCATE”, “UNIFORM”

  • extent_uniform_size (oci.database_management.models.TablespaceStorageSize) – The value to assign to the extent_uniform_size property of this CreateTablespaceDetails.

  • segment_management (str) – The value to assign to the segment_management property of this CreateTablespaceDetails. Allowed values for this property are: “AUTO”, “MANUAL”

  • is_default (bool) – The value to assign to the is_default property of this CreateTablespaceDetails.

property auto_extend_max_size

Gets the auto_extend_max_size of this CreateTablespaceDetails. The maximum disk space allowed for automatic extension of the data files or temp files.

Returns

The auto_extend_max_size of this CreateTablespaceDetails.

Return type

oci.database_management.models.TablespaceStorageSize

property auto_extend_next_size

Gets the auto_extend_next_size of this CreateTablespaceDetails. The size of the next increment of disk space to be allocated automatically when more extents are required.

Returns

The auto_extend_next_size of this CreateTablespaceDetails.

Return type

oci.database_management.models.TablespaceStorageSize

property block_size_in_kilobytes

Gets the block_size_in_kilobytes of this CreateTablespaceDetails. Block size for the tablespace.

Returns

The block_size_in_kilobytes of this CreateTablespaceDetails.

Return type

int

property credential_details

Gets the credential_details of this CreateTablespaceDetails.

Returns

The credential_details of this CreateTablespaceDetails.

Return type

oci.database_management.models.TablespaceAdminCredentialDetails

property data_files

Gets the data_files of this CreateTablespaceDetails. The list of data files or temp files created for the tablespace.

Returns

The data_files of this CreateTablespaceDetails.

Return type

list[str]

property database_credential

Gets the database_credential of this CreateTablespaceDetails.

Returns

The database_credential of this CreateTablespaceDetails.

Return type

oci.database_management.models.DatabaseCredentialDetails

property default_compress

Gets the default_compress of this CreateTablespaceDetails. The default compression of data for all tables created in the tablespace.

Allowed values for this property are: “NO_COMPRESS”, “BASIC_COMPRESS”

Returns

The default_compress of this CreateTablespaceDetails.

Return type

str

property encryption_algorithm

Gets the encryption_algorithm of this CreateTablespaceDetails. The name of the encryption algorithm to be used for tablespace encryption.

Returns

The encryption_algorithm of this CreateTablespaceDetails.

Return type

str

property extent_management

Gets the extent_management of this CreateTablespaceDetails. Specifies how the extents of the tablespace should be managed.

Allowed values for this property are: “AUTOALLOCATE”, “UNIFORM”

Returns

The extent_management of this CreateTablespaceDetails.

Return type

str

property extent_uniform_size

Gets the extent_uniform_size of this CreateTablespaceDetails. The size of the extent when the tablespace is managed with uniform extents of a specific size.

Returns

The extent_uniform_size of this CreateTablespaceDetails.

Return type

oci.database_management.models.TablespaceStorageSize

property file_count

Gets the file_count of this CreateTablespaceDetails. The number of data files or temp files created for the tablespace. This is for Oracle Managed Files only.

Returns

The file_count of this CreateTablespaceDetails.

Return type

int

property file_size

Gets the file_size of this CreateTablespaceDetails. The size of each data file or temp file.

Returns

The file_size of this CreateTablespaceDetails.

Return type

oci.database_management.models.TablespaceStorageSize

property is_auto_extensible

Gets the is_auto_extensible of this CreateTablespaceDetails. Specifies whether the data file or temp file can be extended automatically.

Returns

The is_auto_extensible of this CreateTablespaceDetails.

Return type

bool

property is_bigfile

Gets the is_bigfile of this CreateTablespaceDetails. Specifies whether the tablespace is a bigfile or smallfile tablespace. A bigfile tablespace contains only one data file or temp file, which can contain up to approximately 4 billion (232) blocks. A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 data files or temp files, each of which can contain up to approximately 4 million (222) blocks.

Returns

The is_bigfile of this CreateTablespaceDetails.

Return type

bool

property is_default

Gets the is_default of this CreateTablespaceDetails. Specifies whether the tablespace is the default tablespace.

Returns

The is_default of this CreateTablespaceDetails.

Return type

bool

property is_encrypted

Gets the is_encrypted of this CreateTablespaceDetails. Indicates whether the tablespace is encrypted.

Returns

The is_encrypted of this CreateTablespaceDetails.

Return type

bool

property is_max_size_unlimited

Gets the is_max_size_unlimited of this CreateTablespaceDetails. Specifies whether the disk space of the data file or temp file can be limited.

Returns

The is_max_size_unlimited of this CreateTablespaceDetails.

Return type

bool

property is_reusable

Gets the is_reusable of this CreateTablespaceDetails. Specifies whether Oracle can reuse the data file or temp file. Reuse is only allowed when the file name is provided.

Returns

The is_reusable of this CreateTablespaceDetails.

Return type

bool

property name

[Required] Gets the name of this CreateTablespaceDetails. The name of the tablespace. It must be unique within a database.

Returns

The name of this CreateTablespaceDetails.

Return type

str

property segment_management

Gets the segment_management of this CreateTablespaceDetails. Specifies whether tablespace segment management should be automatic or manual.

Allowed values for this property are: “AUTO”, “MANUAL”

Returns

The segment_management of this CreateTablespaceDetails.

Return type

str

property status

Gets the status of this CreateTablespaceDetails. The status of the tablespace.

Allowed values for this property are: “READ_ONLY”, “READ_WRITE”

Returns

The status of this CreateTablespaceDetails.

Return type

str

property type

Gets the type of this CreateTablespaceDetails. The type of tablespace.

Allowed values for this property are: “PERMANENT”, “TEMPORARY”

Returns

The type of this CreateTablespaceDetails.

Return type

str