OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Migration Service

V4.2.3Enterprise Edition

  • OMS Documentation
  • OMS Introduction
    • What is OMS?
    • Terms
    • OMS HA
    • Architecture
      • Overview
      • Hierarchical functional system
      • Basic components
    • OMS Oracle full data migration design and impact
    • Limitations
  • Quick Start
    • Data migration process
    • Data synchronization process
  • Deploy OMS
    • Environment preparations
    • Memory and disk requirements
    • Deployment types
    • Check the deployment
    • Scale out OMS
    • Integrate the OIDC protocol to OMS to implement SSO
    • Deploy OMS on multiple nodes in multiple regions
    • System and network requirements
    • Deploy OMS on multiple nodes in a single region
    • Single-node deployment
    • Deploy a time-series database (Optional)
  • OMS console
    • Overview
    • Log on to the OMS console
    • User center
      • Change your logon password
      • Log off
      • Configure user information
  • Data migration
    • Overview
    • Migrate data from a MySQL database to a MySQL tenant of OceanBase Database
    • Migrate data from a MySQL tenant of OceanBase Database to a MySQL database
    • Migrate data from an Oracle database to a MySQL tenant of OceanBase Database
    • Migrate data from an Oracle tenant of OceanBase Database to an Oracle database
    • Migrate data from an Oracle database to an Oracle tenant of OceanBase Database
    • Migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
    • Migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
    • Migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
    • Migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
    • Migrate data within OceanBase Database
    • Active-active disaster recovery between OceanBase databases
    • Migrate data from a TiDB database to a MySQL tenant of OceanBase Database
    • Migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
    • Migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
    • Manage data migration projects
      • Start and pause a data migration project
      • Use tags to manage data migration projects
      • Download and import settings of migration objects
      • View and modify migration objects
      • Rename a data migration project
      • Release and delete a data migration project
      • View details of a data migration project
      • Perform batch operations on data migration projects
    • Supported DDL operations and limits for synchronization
      • DDL synchronization from a MySQL database to a MySQL tenant of OceanBase Database
        • Overview of DDL synchronization from a MySQL database to a MySQL tenant of OceanBase Database
        • CREATE TABLE
          • Create a table
          • Create a column
          • Create an index or a constraint
          • Create partitions
        • Data type conversion
        • ALTER TABLE
          • Modify a table
          • Operations on columns
          • Operations on partitions
          • Operations on constraints and indexes
        • TRUNCATE TABLE
        • RENAME TABLE
        • DROP TABLE
        • CREATE INDEX
        • DROP INDEX
        • DDL incompatibilities between a MySQL database and a MySQL tenant of OceanBase Database
          • Overview
          • Incompatibilities of DROP INDEX operations
          • Incompatibilities of the ALTER TABLE statement
            • Delete a constrained column
            • Incompatibilities of ALTER TABLE
            • Change the length of a constrained column
            • Change the type of a constrained column
            • Change the length of an unconstrained column
            • Change the type of an unconstrained column
          • Incompatibilities of the CREATE TABLE statement
            • Incompatibilities of CREATE TABLE
            • Column types that are supported to create indexes or constraints
      • Synchronize DDL operations from a MySQL tenant of OceanBase Database to a MySQL database
      • DDL operations for synchronizing data from an Oracle database to an Oracle tenant of OceanBase Database
        • Overview
        • CREATE TABLE
          • Overview
          • Create a relational table
            • Create a relational table
            • Define columns of a relational table
          • Virtual columns
          • Regular columns
          • Create partitions
            • User-defined partitioning
            • Composite partitioning
            • Overview
            • Subpartition templates
            • Subpartitioning
            • Partitioning
          • Constraints
            • Overview
            • Inline constraints
            • Out-of-line constraints
        • CREATE INDEX
          • Overview
          • Normal indexes
        • ALTER TABLE
          • Modify, drop, and add constraints
          • Modify, drop, and add table attributes
          • Modify tables
          • Column attribute management
            • Modify, drop, and add column attributes
            • Rename a column
            • Add columns and column attributes
            • Modify column attributes
            • Drop columns
          • Partition management
            • Drop subpartitions
            • Modify partitions
            • Drop partitions
            • Truncate partitions
            • Modify, drop, and add partitions
            • Add partitions and subpartitions
        • DROP TABLE
        • COMMENT
        • RENAME OBJECT
        • TRUNCATE TABLE
        • DROP INDEX
        • DDL incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database
          • Overview
          • Incompatibilities of CREATE TABLE
          • Incompatibilities in table modification operations
            • Incompatibilities of ALTER TABLE
            • Change the type of a constrained column
            • Change the type of an unconstrained column
            • Change the length of a constrained column
            • Change the length of an unconstrained column
      • Synchronize DDL operations from an Oracle tenant of OceanBase Database to an Oracle database
      • Synchronize DDL operations from a DB2 LUW database to an Oracle tenant of OceanBase Database
      • Synchronize DDL operations from an Oracle tenant of OceanBase Database to a DB2 LUW database
      • Synchronize DDL operations from a DB2 LUW database to a MySQL tenant of OceanBase Database
      • Synchronize DDL operations from a MySQL tenant of OceanBase Database to a DB2 LUW database
      • DDL synchronization between MySQL tenants of OceanBase Database
      • DDL synchronization between Oracle tenants of OceanBase Database
  • Data synchronization
    • Overview
    • Synchronize data from OceanBase Database to a Kafka instance
    • Synchronize data from OceanBase Database to a RocketMQ instance
    • Synchronize data from OceanBase Database to a DataHub instance
    • Synchronize data from an ODP logical table to a physical table in a MySQL tenant of OceanBase Database
    • Synchronize data from an ODP logical table to a DataHub instance
    • Synchronize data from an IDB logical table to a physical table in a MySQL tenant of OceanBase Database
    • Synchronize data from an IDB logical table to a DataHub instance
    • Synchronize data from a MySQL database to a DataHub instance
    • Synchronize data from an Oracle database to a DataHub instance
    • Manage data synchronization projects
      • View details of a data synchronization project
      • Download and import the settings of synchronization objects
      • View and modify synchronization objects
      • Release and delete a data synchronization project
      • Start and pause a data synchronization project
      • Perform batch operations on data synchronization projects
      • Change the name of a data synchronization project
      • Use tags to manage data synchronization projects
  • Create and manage data sources
    • Create data sources
      • Create a RocketMQ data source
      • Create an Oracle data source
      • Create a DB2 LUW data source
      • Create a TiDB data source
      • Create a PostgreSQL data source
      • Create a Kafka data source
      • Create a DataHub data source
      • Create a MySQL data source
      • Create an OceanBase data source
        • Create an ODP data source
        • Create an IDB data source
        • Create a public cloud OceanBase data source
        • Create a physical OceanBase data source
    • Manage data sources
      • Copy a data source
      • Delete a data source
      • Edit a data source
      • View data source information
    • Create a database user
    • User privileges
    • Enable binlogs for the MySQL database
    • Minimum privileges required when an Oracle database serves as the source
  • OPS & Monitoring
    • O&M overview
    • Go to the overview page
    • Server
      • Update the quota
      • View server logs
      • View server information
    • Components
      • Store
        • Create a store
        • Start and pause a store
        • Update the configurations of a store
        • Delete a store
        • View details of a store
      • Incr-Sync
        • Update the configurations of an Incr-Sync component
        • View details of an Incr-Sync component
        • Migrate an Incr-Sync component
        • Delete an Incr-Sync component
        • Start and pause an Incr-Sync component
        • Batch O&M
      • Full-Import
        • View details of a Full-Import component
        • Pause a Full-Import component
        • Rerun and resume a Full-Import component
        • Update the configurations of a Full-Import component
        • Delete a Full-Import component
      • Full-Verification
        • View details of a Full-Verification component
        • Pause a Full-Verification component
        • Rerun and resume a Full-Verification component
        • Update the configurations of a Full-Verification component
        • Delete a Full-Verification component
    • O&M Task
      • View O&M tasks
      • Skip a task or subtask
      • Retry a task or subtask
    • Parameter Template
      • Overview
      • Component parameters
        • Full-Import parameters
        • Store parameters
        • Full-Verification parameters
        • Supervisor parameters
        • Incr-Sync parameters
        • CM parameters
      • Component Template
        • Delete a component template
        • Copy and export a component template
        • View and edit component templates
        • Create a component template
      • Project Template
        • Create a project template
        • Copy and export a project template
        • View and edit project templates
        • Delete a project template
  • System management
    • Permission Management
      • Overview
      • Manage users
      • Manage departments
    • Alert center
      • Manage alert settings
      • View system alerts
      • View project alerts
    • Associate with OCP
    • System parameters
      • Modify HA configurations
      • oblogproxy parameters
      • Modify system parameters
    • Operation audit
  • Troubleshooting Guide
    • OMS logs
    • Set throttling
    • Store performance diagnostics
    • Manage OMS services
    • Component tuning
      • Oracle store tuning
      • Incr-Sync/Full-Import tuning
    • Component O&M
      • O&M operations for the Supervisor component
      • CLI-based O&M for the Connector component
      • O&M operations for the Store component
  • Reference Guide
    • Features
      • Change the topic
      • Hidden column mechanisms
      • Column filtering
      • Rename a migration or synchronization object
      • DML filtering
      • Configure matching rules for migration objects
      • Data formats
      • Use SQL conditions to filter data
      • DDL synchronization
      • Instructions on schema migration
      • Set an incremental synchronization timestamp
      • Create and update a heartbeat table
      • Wildcard patterns supported for matching rules
    • API Reference
      • StopProject
      • Overview
      • ListProjects
      • CreateOceanBaseODPDataSource
      • DescribeProjectStepMetric
      • ListProjectFullVerifyResult
      • DeleteProject
      • ResumeProject
      • DescribeProject
      • CreateMysqlDataSource
      • DeleteDataSource
      • CreateOceanBaseDataSource
      • CreateLabel
      • ListProjectModifyRecords
      • ListAllLabels
      • CreateProjectModifyRecords
      • CancelProjectModifyRecord
      • DescribeProjectSteps
      • ListDataSource
      • StartProjectsByLabel
      • ReleaseProject
      • RetryProjectModifyRecords
      • StartProject
      • DescribeProjectProgress
      • StopProjectsByLabel
      • DescribeProjectComponents
      • CreateProject
      • StopProjectModifyRecords
      • SubmitPreCheck
      • GetPreCheckResult
    • Alert Reference
      • oms_host_down_migrate_resource
      • oms_sync_status_inconsistent
      • oms_host_threshold
      • oms_migration_delay
      • oms_host_down
      • oms_sync_delay
      • oms_migration_failed
      • oms_sync_failed
    • OMS error codes
    • SQL statements for querying table objects
    • Create a trigger
    • Change the log level for a PostgreSQL instance
  • Upgrade Guide
    • Overview
    • Upgrade OMS in single-node deployment mode
    • Upgrade OMS in multi-node deployment mode
    • FAQ
  • FAQ
    • General O&M
      • How do I modify the resource quotas of an OMS container?
      • How do I troubleshoot the OMS server down issue?
      • Deploy InfluxDB for OMS
      • Increase the disk space of the OMS host
    • Project diagnostics
      • How do I troubleshoot common problems with Oracle Store?
      • How do I perform performance tuning for Oracle Store?
      • What do I do when Oracle Store reports an error at the isUpdatePK stack?
      • What do I do when a store does not have data of the timestamp requested by the downstream?
      • What do I do when OceanBase Store failed to access an OceanBase cluster through RPC?
      • How do I use LogMiner to pull data from an Oracle database?
    • OPS & monitoring
      • What are the alert rules?
    • Data synchronization
      • FAQ about synchronization to a message queue
        • What are the strategies for ensuring the message order in incremental data synchronization to Kafka
    • Data migration
      • User privileges
        • What privileges do I need to grant to a user during data migration to or from an Oracle database?
      • Full migration
        • How do I query the ID of a checker?
        • How do I query log files of the Checker component of OMS?
        • How do I query the verification result files of the Checker component of OMS?
        • What do I do if the destination table does not exist?
        • What can I do when the full migration failed due to LOB fields?
        • What do I do if garbled characters cannot be written into OceanBase Database V3.1.2?
      • Incremental synchronization
        • How do I skip DDL statements?
        • How do I migrate an Oracle database object whose name exceeds 30 bytes in length?
        • How do I update whitelists and blacklists?
        • What are the application scope and limits of ETL?
    • Installation and deployment
      • How do I upgrade Store?
  • Release Note
    • V3.3
      • OMS V3.3.1
      • OMS V3.3.0
    • V4.2
      • OMS V4.2.2
      • OMS V4.2.1
      • OMS V4.2.0
    • V4.0
      • OMS V4.0.2
      • OMS V4.0.1
    • V3.2
      • OMS V3.2.1
      • OMS V3.2.2
    • V3.1
      • OMS V3.1.0
    • V3.4
      • OMS V3.4.0
    • V2.1
      • OMS V2.1.2
      • OMS V2.1.0
    • V4.1
      • OMS V4.1.0

Download PDF

OMS Documentation What is OMS? Terms OMS HA Overview Hierarchical functional system Basic components OMS Oracle full data migration design and impact Limitations Data migration process Data synchronization process Environment preparations Memory and disk requirements Deployment types Check the deployment Scale out OMS Integrate the OIDC protocol to OMS to implement SSO Deploy OMS on multiple nodes in multiple regions System and network requirements Deploy OMS on multiple nodes in a single region Single-node deployment Deploy a time-series database (Optional) Overview Log on to the OMS console Change your logon password Log off Configure user information Overview Migrate data from a MySQL database to a MySQL tenant of OceanBase Database Migrate data from a MySQL tenant of OceanBase Database to a MySQL database Migrate data from an Oracle database to a MySQL tenant of OceanBase Database Migrate data from an Oracle tenant of OceanBase Database to an Oracle database Migrate data from an Oracle database to an Oracle tenant of OceanBase Database Migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database Migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database Migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database Migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database Migrate data within OceanBase Database Active-active disaster recovery between OceanBase databases Migrate data from a TiDB database to a MySQL tenant of OceanBase Database Migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database Migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database Start and pause a data migration project Use tags to manage data migration projects Download and import settings of migration objects View and modify migration objects Rename a data migration project Release and delete a data migration project View details of a data migration project Perform batch operations on data migration projects Synchronize DDL operations from a MySQL tenant of OceanBase Database to a MySQL database Synchronize DDL operations from an Oracle tenant of OceanBase Database to an Oracle database Synchronize DDL operations from a DB2 LUW database to an Oracle tenant of OceanBase Database Synchronize DDL operations from an Oracle tenant of OceanBase Database to a DB2 LUW database Synchronize DDL operations from a DB2 LUW database to a MySQL tenant of OceanBase Database Synchronize DDL operations from a MySQL tenant of OceanBase Database to a DB2 LUW database DDL synchronization between MySQL tenants of OceanBase Database DDL synchronization between Oracle tenants of OceanBase Database Overview Synchronize data from OceanBase Database to a Kafka instance Synchronize data from OceanBase Database to a RocketMQ instance Synchronize data from OceanBase Database to a DataHub instance Synchronize data from an ODP logical table to a physical table in a MySQL tenant of OceanBase Database Synchronize data from an ODP logical table to a DataHub instance Synchronize data from an IDB logical table to a physical table in a MySQL tenant of OceanBase Database Synchronize data from an IDB logical table to a DataHub instance Synchronize data from a MySQL database to a DataHub instance Synchronize data from an Oracle database to a DataHub instance View details of a data synchronization project Download and import the settings of synchronization objects View and modify synchronization objects Release and delete a data synchronization project Start and pause a data synchronization project Perform batch operations on data synchronization projects Change the name of a data synchronization project Use tags to manage data synchronization projects Create a RocketMQ data source Create an Oracle data source Create a DB2 LUW data source Create a TiDB data source Create a PostgreSQL data source Create a Kafka data source Create a DataHub data source Create a MySQL data source Copy a data source Delete a data source Edit a data source View data source information Create a database user User privileges Enable binlogs for the MySQL database Minimum privileges required when an Oracle database serves as the source O&M overview Go to the overview page Update the quota View server logs View server information View O&M tasks Skip a task or subtask Retry a task or subtask
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Migration Service
  3. V4.2.3
iconOceanBase Migration Service
V 4.2.3Enterprise Edition
Enterprise Edition
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.4
  • V 4.2.3
  • V 4.0.2
  • V 3.4.0
Community Edition
  • V 4.2.12
  • V 4.2.11
  • V 4.2.10
  • V 4.2.9
  • V 4.2.8
  • V 4.2.7
  • V 4.2.6
  • V 4.2.5
  • V 4.2.4
  • V 4.2.3
  • V 4.2.1
  • V 4.2.0
  • V 4.0.0
  • V 3.3.1

Copy and export a project template

Last Updated:2024-08-16 06:00:53  Updated
share
What is on this page
Copy a project template
Export a project template

folded

share

This topic describes how to copy and export an existing project template in OceanBase Migration Service (OMS).

Copy a project template

  1. Log on to the OMS console.

  2. In the left-side navigation pane, choose O&M and Monitoring > Parameter Template. The Project Template tab automatically appears.

    template-6-en

  3. On the Project Template tab, find the project template that you want to copy, and click Copy in the Actions column.

    template-19-en

  4. In the Copy Project Template dialog box, confirm the parameters. You can also modify the parameters as needed.

    template-20-en

    Parameter Description
    Template Name By default, -1 is appended to the original template name. You can enter a custom template name. It must not contain any spaces and cannot exceed 64 characters in length.
    Store Component Template Select an existing component template from the drop-down list. Supported Store component types are MySQL, Oracle, OceanBase, DB2, and PostgreSQL. You can add at most two types of Store component templates.
    Incr-Sync Component Template Select an existing component template from the drop-down list. Supported Incr-Sync component types are Forward, Reverse, and Bidirectional. You can add at most two types of Incr-Sync component templates.
    Full-Import Component Template Select an existing component template from the drop-down list.
    Full-Verification Component Template Select an existing component template from the drop-down list.
    Remarks Additional information about the project template.
  5. Click OK.

Export a project template

  1. In the left-side navigation pane of the OMS console, choose O&M and Monitoring > Parameter Template. The Project Template tab automatically appears.

  2. On the Project Template tab, find the project template that you want to export, and click Export in the Actions column.

    template-21-en

  3. View the project template that is exported to your local storage. You can edit the project template as needed, and then import the parameter configuration of the template when you create another project template.

    template-10-en

Previous topic

View and edit project templates
Last

Next topic

Delete a project template
Next
What is on this page
Copy a project template
Export a project template