ODC V4.3.0|V4.3.3|OceanBase Developer Center|ODC docs|Distributed Database

OceanBase Developer Center

V4.3.3

Overview
- What is ODC?
- Features
- Architecture
- Limitations
- ODC console
Quick Start
- Client ODC
  - Overview
  - Install Client ODC
  - Use Client ODC
- Web ODC
  - Overview
  - Deploy Web ODC
  - Use Web ODC
Data Source Management
- Create a data source
- Data sources and project collaboration
- Database O&M
  - Session management
  - Global variable management
  - Recycle bin management
SQL Development
- SQL editing and execution
- Perform PL compilation and debugging
- Use the command-line window
- Edit and export the result set of an SQL statement
- Execution analysis
- Generate test data
- Database objects
  - Table objects
    - Overview
    - Create a table
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
Import and Export
- Import schemas and data
- Export schemas and data
Database Change Management
- User Permission Management
  - Users and roles
  - Automatic authorization
- Project collaboration management
- Risk levels, risk identification rules, and approval processes
- SQL check specifications
- SQL window specification
- Database change management
- Logical database change management
- Batch database change management
- Lock-free schema changes
- Synchronize shadow tables
- Schema comparison
Data Lifecycle Management
- Archive data
- Clean up data
- Partitioning Plan Management
  - Manage partitioning plans
  - Set partitioning strategies
  - Examples
- SQL plan task
Data Desensitization and Auditing
- Desensitize data
- Operation records
Notification Management
- Overview
- View notification records
- Manage Notification Channel
  - Create a notification channel
  - View, edit, and delete a notification channel
  - Configure a custom channel
- Manage notification rules
System Integration
- Login integration
- Approval integration
- SQL approval integration
- Bastion host integration
Deployment Guide
- Deployment overview
- Preparations before deployment
- Deploy ODC in single-node mode
- Deploy ODC in high-availability mode
- Deployment verification
Upgrade Guide
- Upgrade Overview
- Preparations before upgrade
- Update single-node ODC
- Update high-avaliability ODC
- Upgrade verification
- Rollback after upgrade failed
Troubleshooting
- ODC troubleshooting process
- Collect Message
  - View the runtime environment and version information
  - View web ODC logs
  - View client ODC logs
  - View end-to-end ODC-related logs
  - View ODC MetaDB data
  - Query the index status in OceanBase Database V4.x
  - Query the index status in OceanBase Database V1.4.x to V3.2.x
  - Collect JVM runtime information
  - Use tcpdump to capture packets
- FAQ
  - Installation of client ODC
  - Web ODC deployment and startup
  - Connection Information
  - Command-line window
  - DDL statement display
Release Note
- V4.3
  - ODC V4.3.3
  - ODC V4.3.2
  - ODC V4.3.1
  - ODC V4.3.0
- V4.2
  - ODC V4.2.4
  - ODC V4.2.3
  - ODC V4.2.2
  - ODC V4.2.1
  - ODC V4.2.0
- V4.1
  - ODC V4.1.3
  - ODC V4.1.2
  - ODC V4.1.1
  - ODC V4.1.0
- V4.0
  - ODC V4.0.2
  - ODC V4.0.0
- V3.4
  - ODC V3.4.0
- V3.3
  - ODC V3.3.3
  - ODC V3.3.2
  - ODC V3.3.1
  - ODC V3.3.0
- V3.2
  - ODC V3.2.3
  - ODC V3.2.2
  - ODC V3.2.1
  - ODC V3.2.0

Download PDF

Company

About OceanBase Contact Us

Product

OceanBase Dedicated OceanBase Database Quick Start Download Pricing

Resources

Docs Blog White Paper Trust Center