DROP DATABASE
语法 DROP DATABASE[IF EXISTS][catalog_name.]db_name 参数说明 参数 是否必选 说明 catalog_name 否 数据库的Catalog。db_name 是 数据库名，用于唯一识别一个数据库。示例 删除名为mydatabase的数据库。DROP DATABASE mydatabase;返回...
alicloud_gpdb_db_instance_plans
This data source provides the Gpdb Db Instance Plans of the current Alibaba Cloud user.->NOTE:Available in v1.189.0+.Example Usage Basic Usage data"alicloud_gpdb_db_instance_plans""ids"{ db_instance_id="example_value"ids=...
概述
本节中的SQL命令适用于Oracle数据库和 PolarDB PostgreSQL版（兼容Oracle）数据库。说明 PolarDB PostgreSQL版（兼容Oracle）支持此处未列出的其他命令。这些命令可能没有Oracle等效命令，提供的功能也可能与Oracle SQL命令类似或相同，但...
alicloud_db_instance
Provides an RDS instance resource.A DB instance is an isolated database environment in the cloud.A DB instance can contain multiple user-created databases.For information about RDS and how to use it,see What is ApsaraDB ...
oracle_fdw
您可以使用oracle_fdw插件与外部的Oracle数据库进行交互。前提条件 oracle_fdw依赖于Oracle Instant Client的动态链接库与Oracle数据库服务器进行交互。可以与oracle_fdw插件协同工作的Oracle Instant Client版本如下所示：11.2 12.1、12.2...
alicloud_rds_ddr_instance
instance_name=data.alicloud_rds_cross_region_backups.backups.db_instance_id } Deleting alicloud_rds_ddr_instance or removing it from your configuration The alicloud_rds_ddr_instance resource allows you to manage payment_...
alicloud_db_readonly_instance
db_instance.example.id engine_version=alicloud_db_instance.example.engine_version instance_storage=alicloud_db_instance.example.instance_storage instance_type=alicloud_db_instance.example.instance_type instance_name="${var...
预检Oracle（ECS）
Oracle数据库状态检查 检查Oracle实例中所有数据库状态是否正常。若不通过，则界面提示的数据库无法进行备份和恢复操作。归档模式检查 检查Oracle实例的归档模式是否正常。若不通过，实例中所有数据库将不能进行备份操作。如何开启Oracle...
ST_AsGeobuf
geomName geom_name是行数据中Geometry列的列名。如果为NULL，则默认为找到的第一个Geometry列。描述 Geobuf无法流式传输。示例 SELECT ST_AsGeobuf(q)FROM(select ST_GeomFromText('POINT(116 40)',4326))as q;st_asgeobuf-\x1800220b0a...
DBA_DB_LINKS
DBA_DB_LINKS 视图提供数据库中的所有 database link 的相关信息。名称 类型 说明 owner TEXT database link 所有者的用户名。db_link TEXT database link 的名称。type CHARACTER VARYING 远程服务器的类型。username TEXT 登录用户的用户...
alicloud_gpdb_instances
HighAvailability,Basic.db_instance_class-The db instance class.db_instance_id-The db instance id.db_instance_mode-The db instance mode.Valid values:StorageElastic,Serverless,Classic.description-The description of the ...
alicloud_mongodb_instance
Provides a MongoDB instance resource supports replica set instances only.the MongoDB provides stable,reliable,and automatic scalable database services.It offers a full range of database solutions,such as disaster recovery,...
实例管理
在terraform.tf文件的 resource"alicloud_db_instance""instance"{} 中增加 instance_name 配置项，具体配置如下：.resource"alicloud_db_instance""instance"{.instance_name="terraformtest"} 运行 terraform apply。出现如下配置信息后...
alicloud_rds_accounts
This data source provides the Rds Accounts of the current Alibaba Cloud user.->NOTE:Available in v1.120.0+.Example Usage Basic Usage data"alicloud_rds_accounts""example"{ db_instance_id="example_value"name_regex="the_...
alicloud_rds_db_instance_endpoint_address
db_instance_endpoint""default"{ db_instance_id=alicloud_rds_db_node.default.db_instance_id vpc_id=alicloud_vpc.default.id vswitch_id=alicloud_db_instance.default.vswitch_id connection_string_prefix="example"port="3306"db_...
alicloud_kvstore_instances
instance_name instead.db_instance_name-The name of the instance.charge_type-It has been deprecated from provider version 1.101.0 and payment_type instead.payment_type-Billing method.Valid Values:PostPaid for Pay-As-You-Go ...
alicloud_drds_instances
The alicloud_drds_instance data source provides a collection of DRDS instances available in Alibaba Cloud account.Filters support regular expression for the instance name,searches by tags,and other filters which are listed...
alicloud_rds_db_instance_endpoint
see What is RDS DB Instance Endpoint.->NOTE:Available since v1.203.0.Example Usage provider"alicloud"{ region=...id=data.alicloud_db_zones.default.ids.0 vswitch_name=var.name } resource"alicloud_security_group""default"{ ...
alicloud_rds_backup
type="rds.mysql.t1.small"instance_storage="30"instance_charge_type="Postpaid"db_instance_storage_type="local_ssd"} resource"alicloud_rds_backup""example"{ db_instance_id=alicloud_db_instance.example.id } Argument Reference...
alicloud_mongodb_sharding_instance
Provides a MongoDB Sharding Instance resource supports replica set instances only.the MongoDB provides stable,reliable,and automatic scalable database services.It offers a full range of database solutions,such as disaster ...
alicloud_rds_db_node
zones.default.ids.0 } resource"alicloud_rds_db_node""default"{ db_instance_id=alicloud_db_instance.default.id class_code=alicloud_db_instance.default.instance_type zone_id=alicloud_vswitch.default.zone_id } Argument ...
alicloud_mongodb_instances
The alicloud_mongodb_instances data source provides a collection of MongoDB instances available in Alicloud account.Filters support regular expression for the instance name,engine or instance type.Example Usage data...
alicloud_db_read_write_splitting_connection
db_instance.example.zone_id master_db_instance_id=alicloud_db_instance.example.id engine_version=alicloud_db_instance.example.engine_version instance_storage=alicloud_db_instance.example.instance_storage instance_type=...
alicloud_graph_database_db_instance
Provides a Graph Database Db Instance resource.For information about Graph Database Db Instance and how to use it,see What is Db Instance.->NOTE:Available since v1.136.0.Example Usage Basic Usage variable"name"{ default=...
alicloud_rds_upgrade_db_instance
Provides a RDS Upgrade DB Instance resource.For information about RDS Upgrade DB Instance and how to use it,see What is ApsaraDB for RDS.->NOTE:Available since v1.153.0+.Example Usage Create a RDS PostgreSQL upgrade ...
alicloud_dbfs_instances
name-The name of the Database file system.kms_key_id-The KMS key ID of the Database file system used.This parameter is valid When encryption parameter is set to true.payment_type-Thr payment type of the Database file ...
alicloud_dts_consumer_channel
storage=data.alicloud_db_instance_classes.example.instance_classes.0.storage_range.min instance_charge_type="Postpaid"instance_name=var.name vswitch_id=alicloud_vswitch.example.id monitoring_period="60"db_instance_...
alicloud_graph_database_db_instances
database_db_instance_id_1"{ value=data.alicloud_graph_database_db_instances.ids.instances.0.id } data"alicloud_graph_database_db_instances""status"{ ids=["example_id"]status="Running"} output"graph_database_db_instance_id_...
alicloud_sddp_data_limit
db_instance.default.id account_name=var.name account_password="Example1234"} resource"alicloud_db_database""default"{ instance_id=alicloud_db_instance.default.id name=var.name } resource"alicloud_db_account_privilege"...
alicloud_dms_enterprise_proxy
version="8.0"db_instance_storage_type="cloud_essd"instance_type=data.alicloud_db_instance_classes.default.instance_classes.0.instance_class instance_storage=data.alicloud_db_instance_classes.default.instance_classes.0....
alicloud_dms_enterprise_instances
timeout-The timeout period for exporting the database instance.host-The endpoint of the database instance.instance_alias-The alias of the database instance.instance_id-The ID of the database instance.instance_source-The ID...
alicloud_rds_clone_db_instance
Provides an RDS Clone DB Instance resource.For information about RDS Clone DB Instance and how to use it,see What is ApsaraDB for RDS.->NOTE:Available since v1.149.0+.Example Usage Create an RDS MySQL clone instance data...
alicloud_db_instances
The alicloud_db_instances data source provides a collection of RDS instances available in Alibaba Cloud account.Filters support regular expression for the instance name,searches by tags,and other filters which are listed ...
alicloud_db_account_privilege
type="rds.mysql.s1.small"instance_storage="10"vswitch_id=alicloud_vswitch.default.id instance_name=var.name } resource"alicloud_db_database""db"{ count=2 instance_id=alicloud_db_instance.instance.id name="${var.name}_${...
GRANT on Database Objects
PolarDB PostgreSQL版（兼容Oracle）中授予 EXECUTE 特权的语法与 Oracle 数据库并不完全兼容。PolarDB PostgreSQL版（兼容Oracle）需要使用以下关键字之一限定程序名称：FUNCTION、PROCEDURE 或 PACKAGE；而在 Oracle 中，必须省略这些...
alicloud_kvstore_instance
instance_name-(Deprecated since v1.101.0)It has been deprecated from provider version 1.101.0 and db_instance_name instead.db_instance_name-(Optional,Available since v1.101.0)The name of KVStore DBInstance.It is a string ...
alicloud_hbr_hana_instances
ids-(Optional,ForceNew,Computed)A list of Hana Instance IDs.name_regex-(Optional,ForceNew)A regex string to filter results by Hana Instance name.output_file-(Optional)File name where to save data source results(after ...
可运维能力
AWR PolarDB PostgreSQL版（兼容Oracle）Global AWR是与Oracle AWR相似的数据库性能诊断工具,它包含监控数据仓库及性能分析报告两部分内容。对比Oracle的AWR，PolarDB PostgreSQL版（兼容Oracle）Global AWR在时间上具有最细粒度到秒级的...
alicloud_dts_job_monitor_rule
period="60"db_instance_storage_type="cloud_essd"security_group_ids=[alicloud_security_group.example.id]} resource"alicloud_rds_account""example"{ count=2 db_instance_id=alicloud_db_instance.example[count.index].id account_...
alicloud_rds_instance_cross_backup_policy
(Defaults to 10 mins)Used when the database instance modifies the remote disaster recovery settings.delete-(Defaults to 10 mins)Used when the database instance shuts down remote disaster recovery.Import RDS remote disaster...
- 产品推荐
- 这些文档可能帮助您