Add a table to a table group

If you do not specify a table group when creating a table, you can add the table to a table group afterward. You can add a table to a table group by changing the table group attribute of the table or using the ALTER TABLEGROUP ADD syntax.

Syntax

ALTER TABLE tblname TABLEGROUP = tablegroupname

ALTER TABLEGROUP tablegroupname ADD [TABLE] tblname [, tblname...]

Parameters

Examples

Example 1

Change the table group of a table:

Note

Do not use single quotation marks (') when changing the table group attribute. Otherwise, the names are case-sensitive.

1. Change the table group of the ordr table.

   obclient> ALTER TABLE ordr TABLEGROUP=tpcc_group;
   Query OK, 0 rows affected
   

2. View the table group attribute.

   obclient> SHOW TABLEGROUPS;
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | oceanbase       | NULL       | NULL          |
   | tgh             | NULL       | NULL          |
   | tpcc_group      | ordr       | test          |
   +-----------------+------------+---------------+
   3 rows in set
   

Example 2

Add a table to a table group.

Note

Before you add a table to a table group, make sure that the table has the same partitioning strategy as that of the table group.

1. View the current table group.

   obclient> SHOW TABLEGROUPS;
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | oceanbase       | NULL       | NULL          |
   | tgh             | NULL       | NULL          |
   | tpcc_group      | NULL       | NULL          |
   +-----------------+------------+---------------+
   3 rows in set
   

2. Add a table to the tpcc_group table group.

   obclient> ALTER TABLEGROUP tpcc_group ADD ordr;
   Query OK, 0 rows affected
   

3. View the information about the current table group.

   obclient> SHOW TABLEGROUPS;
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | oceanbase       | NULL       | NULL          |
   | tgh             | NULL       | NULL          |
   | tpcc_group      | ordr       | test          |
   +-----------------+------------+---------------+
   3 rows in set