DATABASE-MANAGEMENT_TABLESPACE(1)

add

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Adds data files or temp files to the tablespace.

Usage

oci database-management tablespace add [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--file-type [text]

Specifies whether the file is a data file or temp file.

Accepted values are:

DATAFILE, TEMPFILE

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--auto-extend-max-size [complex type]

The maximum disk space allowed for automatic extension of the data files or temp files. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--auto-extend-next-size [complex type]

The size of the next increment of disk space to be allocated automatically when more extents are required. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--data-files [complex type]

The list of data files or temp files added to the tablespace. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--file-count [integer]

The number of data files or temp files to be added for the tablespace. This is for Oracle Managed Files only.

--file-size [complex type]

The size of each data file or temp file. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-auto-extensible [boolean]

Specifies whether the data file or temp file can be extended automatically.

--is-max-size-unlimited [boolean]

Specifies whether the disk space of the data file or temp file can be limited.

--is-reusable [boolean]

Specifies whether Oracle can reuse the data file or temp file. Reuse is only allowed when the file name is provided.

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace add --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export file_type=<substitute-value-of-file_type> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/add.html#cmdoption-file-type
    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/add.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/add.html#cmdoption-tablespace-name
    oci database-management tablespace add --credential-details file://credential-details.json --file-type $file_type --managed-database-id $managed_database_id --tablespace-name $tablespace_name

create

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Creates a tablespace within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace create [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--name [text]

The name of the tablespace. It must be unique within a database.

Optional Parameters

--auto-extend-max-size [complex type]

The maximum disk space allowed for automatic extension of the data files or temp files. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--auto-extend-next-size [complex type]

The size of the next increment of disk space to be allocated automatically when more extents are required. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--block-size-in-kilobytes [integer]

Block size for the tablespace.

--data-files [complex type]

The list of data files or temp files created for the tablespace. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--default-compress [text]

The default compression of data for all tables created in the tablespace.

Accepted values are:

BASIC_COMPRESS, NO_COMPRESS

--encryption-algorithm [text]

The name of the encryption algorithm to be used for tablespace encryption.

--extent-management [text]

Specifies how the extents of the tablespace should be managed.

Accepted values are:

AUTOALLOCATE, UNIFORM

--extent-uniform-size [complex type]

The size of the extent when the tablespace is managed with uniform extents of a specific size. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--file-count [integer]

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

--file-size [complex type]

The size of each data file or temp file. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-auto-extensible [boolean]

Specifies whether the data file or temp file can be extended automatically.

--is-bigfile [boolean]

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.

--is-default [boolean]

Specifies whether the tablespace is the default tablespace.

--is-encrypted [boolean]

Indicates whether the tablespace is encrypted.

--is-max-size-unlimited [boolean]

Specifies whether the disk space of the data file or temp file can be limited.

--is-reusable [boolean]

Specifies whether Oracle can reuse the data file or temp file. Reuse is only allowed when the file name is provided.

--segment-management [text]

Specifies whether tablespace segment management should be automatic or manual.

Accepted values are:

AUTO, MANUAL

--status [text]

The status of the tablespace.

Accepted values are:

READ_ONLY, READ_WRITE

--type [text]

The type of tablespace.

Accepted values are:

PERMANENT, TEMPORARY

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace create --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/create.html#cmdoption-managed-database-id
    export name=<substitute-value-of-name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/create.html#cmdoption-name
    oci database-management tablespace create --credential-details file://credential-details.json --managed-database-id $managed_database_id --name $name

drop

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace drop [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-cascade-constraints [boolean]

Specifies whether all the constraints on the tablespace being dropped should be dropped.

--is-dropping-data-files [boolean]

Specifies whether all the associated data files of the tablespace being dropped should be dropped.

--is-including-contents [boolean]

Specifies whether all the contents of the tablespace being dropped should be dropped.

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace drop --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop.html#cmdoption-tablespace-name
    oci database-management tablespace drop --credential-details file://credential-details.json --managed-database-id $managed_database_id --tablespace-name $tablespace_name

drop-with-pwd

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace drop-with-pwd [OPTIONS]

Required Parameters

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--password [text]

The database user’s password encoded using BASE64 scheme.

--role [text]

The role of the database user.

Accepted values are:

NORMAL, SYSDBA

--tablespace-name [text]

The name of the tablespace.

--username [text]

The user to connect to the database.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-cascade-constraints [boolean]

Specifies whether all the constraints on the tablespace being dropped should be dropped.

--is-dropping-data-files [boolean]

Specifies whether all the associated data files of the tablespace being dropped should be dropped.

--is-including-contents [boolean]

Specifies whether all the contents of the tablespace being dropped should be dropped.

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-pwd.html#cmdoption-managed-database-id
    export password=<substitute-value-of-password> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-pwd.html#cmdoption-password
    export role=<substitute-value-of-role> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-pwd.html#cmdoption-role
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-pwd.html#cmdoption-tablespace-name
    export username=<substitute-value-of-username> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-pwd.html#cmdoption-username
    oci database-management tablespace drop-with-pwd --managed-database-id $managed_database_id --password $password --role $role --tablespace-name $tablespace_name --username $username

drop-with-secret

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Drops the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace drop-with-secret [OPTIONS]

Required Parameters

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--role [text]

The role of the database user.

Accepted values are:

NORMAL, SYSDBA

--secret [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Secret where the database password is stored.

--tablespace-name [text]

The name of the tablespace.

--username [text]

The user to connect to the database.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-cascade-constraints [boolean]

Specifies whether all the constraints on the tablespace being dropped should be dropped.

--is-dropping-data-files [boolean]

Specifies whether all the associated data files of the tablespace being dropped should be dropped.

--is-including-contents [boolean]

Specifies whether all the contents of the tablespace being dropped should be dropped.

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-secret.html#cmdoption-managed-database-id
    export role=<substitute-value-of-role> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-secret.html#cmdoption-role
    export secret=<substitute-value-of-secret> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-secret.html#cmdoption-secret
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-secret.html#cmdoption-tablespace-name
    export username=<substitute-value-of-username> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/drop-with-secret.html#cmdoption-username
    oci database-management tablespace drop-with-secret --managed-database-id $managed_database_id --role $role --secret $secret --tablespace-name $tablespace_name --username $username

get

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace get [OPTIONS]

Required Parameters

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/get.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/get.html#cmdoption-tablespace-name
    oci database-management tablespace get --managed-database-id $managed_database_id --tablespace-name $tablespace_name

list

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Gets the list of tablespaces for the specified managedDatabaseId.

Usage

oci database-management tablespace list [OPTIONS]

Required Parameters

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

Optional Parameters

--all

Fetches all pages of results. If you provide this option, then you cannot provide the --limit option.

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--limit [integer]

The maximum number of records returned in the paginated response.

--name [text]

A filter to return only resources that match the entire name.

--page [text]

The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.

--page-size [integer]

When fetching results, the number of results to fetch per call. Only valid when used with --all or --limit, and ignored otherwise.

--sort-by [text]

The field to sort information by. Only one sortOrder can be used. The default sort order for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending. The ‘NAME’ sort order is case-sensitive.

Accepted values are:

NAME, TIMECREATED

--sort-order [text]

The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order.

Accepted values are:

ASC, DESC

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/list.html#cmdoption-managed-database-id
    oci database-management tablespace list --managed-database-id $managed_database_id

remove

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Removes a data file or temp file from the tablespace.

Usage

oci database-management tablespace remove [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--data-file [text]

Name of the data file or temp file to be removed from the tablespace.

--file-type [text]

Specifies whether the file is a data file or temp file.

Accepted values are:

DATAFILE, TEMPFILE

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace remove --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export data_file=<substitute-value-of-data_file> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove.html#cmdoption-data-file
    export file_type=<substitute-value-of-file_type> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove.html#cmdoption-file-type
    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove.html#cmdoption-tablespace-name
    oci database-management tablespace remove --credential-details file://credential-details.json --data-file $data_file --file-type $file_type --managed-database-id $managed_database_id --tablespace-name $tablespace_name

remove-datafile-with-pwd

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Removes a data file or temp file from the tablespace.

Usage

oci database-management tablespace remove-datafile-with-pwd [OPTIONS]

Required Parameters

--data-file [text]

Name of the data file or temp file to be removed from the tablespace.

--file-type [text]

Specifies whether the file is a data file or temp file.

Accepted values are:

DATAFILE, TEMPFILE

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--password [text]

The database user’s password encoded using BASE64 scheme.

--role [text]

The role of the database user.

Accepted values are:

NORMAL, SYSDBA

--tablespace-name [text]

The name of the tablespace.

--username [text]

The user to connect to the database.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export data_file=<substitute-value-of-data_file> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-data-file
    export file_type=<substitute-value-of-file_type> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-file-type
    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-managed-database-id
    export password=<substitute-value-of-password> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-password
    export role=<substitute-value-of-role> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-role
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-tablespace-name
    export username=<substitute-value-of-username> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-pwd.html#cmdoption-username
    oci database-management tablespace remove-datafile-with-pwd --data-file $data_file --file-type $file_type --managed-database-id $managed_database_id --password $password --role $role --tablespace-name $tablespace_name --username $username

remove-datafile-with-secret

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Removes a data file or temp file from the tablespace.

Usage

oci database-management tablespace remove-datafile-with-secret [OPTIONS]

Required Parameters

--data-file [text]

Name of the data file or temp file to be removed from the tablespace.

--file-type [text]

Specifies whether the file is a data file or temp file.

Accepted values are:

DATAFILE, TEMPFILE

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--role [text]

The role of the database user.

Accepted values are:

NORMAL, SYSDBA

--secret [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Secret where the database password is stored.

--tablespace-name [text]

The name of the tablespace.

--username [text]

The user to connect to the database.

Optional Parameters

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export data_file=<substitute-value-of-data_file> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-data-file
    export file_type=<substitute-value-of-file_type> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-file-type
    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-managed-database-id
    export role=<substitute-value-of-role> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-role
    export secret=<substitute-value-of-secret> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-secret
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-tablespace-name
    export username=<substitute-value-of-username> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/remove-datafile-with-secret.html#cmdoption-username
    oci database-management tablespace remove-datafile-with-secret --data-file $data_file --file-type $file_type --managed-database-id $managed_database_id --role $role --secret $secret --tablespace-name $tablespace_name --username $username

resize-data-file

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Resizes a data file or temp file within the tablespace.

Usage

oci database-management tablespace resize-data-file [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--data-file [text]

Name of the data file or temp file to be resized.

--file-type [text]

Specifies whether the file is a data file or temp file.

Accepted values are:

DATAFILE, TEMPFILE

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--auto-extend-max-size [complex type]

The maximum disk space allowed for automatic extension of the data files or temp files. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--auto-extend-next-size [complex type]

The size of the next increment of disk space to be allocated automatically when more extents are required. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--file-size [complex type]

The new size of the data file or temp file. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-auto-extensible [boolean]

Specifies whether the data file or temp file can be extended automatically.

--is-max-size-unlimited [boolean]

Specifies whether the disk space of the data file or temp file can be limited.

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace resize-data-file --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export data_file=<substitute-value-of-data_file> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/resize-data-file.html#cmdoption-data-file
    export file_type=<substitute-value-of-file_type> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/resize-data-file.html#cmdoption-file-type
    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/resize-data-file.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/resize-data-file.html#cmdoption-tablespace-name
    oci database-management tablespace resize-data-file --credential-details file://credential-details.json --data-file $data_file --file-type $file_type --managed-database-id $managed_database_id --tablespace-name $tablespace_name

update

Description
Usage
Required Parameters
Optional Parameters
Global Parameters
Examples

Description

Updates the attributes of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

Usage

oci database-management tablespace update [OPTIONS]

Required Parameters

--credential-details [complex type]

This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--managed-database-id [text]

The OCID <https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm> of the Managed Database.

--tablespace-name [text]

The name of the tablespace.

Optional Parameters

--auto-extend-max-size [complex type]

The maximum disk space allowed for automatic extension of the data files or temp files. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--auto-extend-next-size [complex type]

The size of the next increment of disk space to be allocated automatically when more extents are required. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--file-size [complex type]

The size of each data file or temp file. This is a complex type whose value must be valid JSON. The value can be provided as a string on the command line or passed in as a file using the file://path/to/file syntax.

The --generate-param-json-input option can be used to generate an example of the JSON which must be provided. We recommend storing this example in a file, modifying it as needed and then passing it back in via the file:// syntax.

--force

Perform update without prompting for confirmation.

--from-json [text]

Provide input to this command as a JSON document from a file using the file://path-to/file syntax.

The --generate-full-command-json-input option can be used to generate a sample json file to be used with this command option. The key names are pre-populated and match the command option names (converted to camelCase format, e.g. compartment-id –> compartmentId), while the values of the keys need to be populated by the user before using the sample file as an input to this command. For any command option that accepts multiple values, the value of the key can be a JSON array.

Options can still be provided on the command line. If an option exists in both the JSON document and the command line then the command line specified value will be used.

For examples on usage of this option, please see our “using CLI with advanced JSON options” link: https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliusing.htm#AdvancedJSONOptions

--is-auto-extensible [boolean]

Specifies whether the data file or temp file can be extended automatically.

--is-default [boolean]

Specifies whether the tablespace is the default tablespace.

--is-max-size-unlimited [boolean]

Specifies whether the disk space of the data file or temp file can be limited.

--name [text]

The name of the tablespace. It must be unique within a database.

--status [text]

The status of the tablespace.

Accepted values are:

READ_ONLY, READ_WRITE

--type [text]

The type of tablespace.

Accepted values are:

PERMANENT, TEMPORARY

Global Parameters

Use oci --help for help on global parameters.

--auth-purpose, --auth, --cert-bundle, --cli-auto-prompt, --cli-rc-file, --config-file, --debug, --defaults-file, --endpoint, --generate-full-command-json-input, --generate-param-json-input, --help, --latest-version, --max-retries, --no-retry, --opc-client-request-id, --opc-request-id, --output, --profile, --query, --raw-output, --region, --release-info, --request-id, --version, -?, -d, -h, -i, -v

Examples

Copy and paste the following example into a JSON file, replacing the example parameters with your own.

    oci database-management tablespace update --generate-param-json-input credential-details > credential-details.json

Copy the following CLI commands into a file named example.sh. Run the command by typing “bash example.sh” and replacing the example parameters with your own.

Please note this sample will only work in the POSIX-compliant bash-like shell. You need to set up the OCI configuration <https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#configfile> and appropriate security policies <https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/policygetstarted.htm> before trying the examples.

    export managed_database_id=<substitute-value-of-managed_database_id> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/update.html#cmdoption-managed-database-id
    export tablespace_name=<substitute-value-of-tablespace_name> # https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/latest/oci_cli_docs/cmdref/database-management/tablespace/update.html#cmdoption-tablespace-name
    oci database-management tablespace update --credential-details file://credential-details.json --managed-database-id $managed_database_id --tablespace-name $tablespace_name