默认情况 OceanBase 没有创建示例数据库 TPCC，需要手动创建。示例数据库必须在业务租户下创建。有关示例数据库介绍请参考 关于示例数据库TPCC。

租户创建好后，需要创建相应的 Schema 来存放示例数据库的对象，还要分配相应的用户和访问权限。

示例

  1. 通过 obclient 连接 Oracle 租户。具体方法请参考 通过 obclient 连接 OceanBase 租户。
  1. $obclient -h192.168.1.101 -usys@t_oracle0_91#obdoc -P2883 -pabcABC123  sys
  2. obclient: [Warning] Using a password on the command line interface can be insecure.
  3. Welcome to the OceanBase monitor.  Commands end with ; or \g.
  4. Your OceanBase connection id is 58725
  5. Server version: 5.6.25 OceanBase 2.2.20 (…) (Built Aug 10 2019 15:27:33)
  7. <…省略…>
  9. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  11. obclient>
  1. 创建一个 Schema，即用户。
  1. obclient> create user tpcc identified by 123456;
  2. Query OK, 0 rows affected (0.02 sec)
  4. obclient> grant all privileges on tpcc.* to tpcc;
  5. Query OK, 0 rows affected (0.02 sec)
  7. obclient> grant create,drop,select on *.* to tpcc;
  8. Query OK, 0 rows affected (0.01 sec)
  10. obclient> grant select on sys.* to tpcc;
  11. Query OK, 0 rows affected (0.02 sec)
  13. obclient> show grants for tpcc;
  14. +---------------------------------------------+
  15. | Grants for TPCC@%                           |
  16. +---------------------------------------------+
  17. | GRANT CREATE, DROP, SELECT ON *.* TO 'TPCC' |
  18. | GRANT SELECT ON "SYS".* TO 'TPCC'           |
  19. | GRANT ALL PRIVILEGES ON "TPCC".* TO 'TPCC'  |
  20. +---------------------------------------------+
  21. 3 rows in set (0.00 sec)
  1. 通过用户 tpcc 登录到 tpcc 模式下。
  1. $obclient -h192.168.1.101 -utpcc@t_oracle0_91#obdoc -P2883 -p123456 tpcc
  1. 创建数据库对象
  1. obclient> source create_tables_oracle.sql
  2. Query OK, 0 rows affected (0.21 sec)
  4. <…省略…>
  6. Query OK, 0 rows affected (0.07 sec)
  8. +-----------+------------+-------------+-----------+
  9. | SYSDATE   | TABLE_NAME | PARTITIONED | TEMPORARY |
  10. +-----------+------------+-------------+-----------+
  11. | 01-APR-20 | CUST       | YES         | N         |
  12. | 01-APR-20 | DIST       | YES         | N         |
  13. | 01-APR-20 | HIST       | YES         | N         |
  14. | 01-APR-20 | ITEM       | NO          | N         |
  15. | 01-APR-20 | LOAD_HIST  | NO          | N         |
  16. | 01-APR-20 | LOAD_PROC  | NO          | N         |
  17. | 01-APR-20 | NORD       | YES         | N         |
  18. | 01-APR-20 | ORDL       | YES         | N         |
  19. | 01-APR-20 | ORDR       | YES         | N         |
  20. | 01-APR-20 | STOK       | YES         | N         |
  21. | 01-APR-20 | WARE       | YES         | N         |
  22. +-----------+------------+-------------+-----------+
  23. 11 rows in set (0.02 sec)

5. 初始化表数据。

  1. obclient> source init_data.sql
  2. Query OK, 0 rows affected (0.01 sec)
  3. <…省略…>
  4. Query OK, 0 rows affected (0.01 sec)
  6. Query OK, 1 row affected (0.00 sec)
  8. Query OK, 0 rows affected (0.03 sec)
  10. +------------+----------+
  11. | TABLE_NAME | ROWS_CNT |
  12. +------------+----------+
  13. | WARE       |        2 |
  14. | DIST       |       20 |
  15. | NORD       |       40 |
  16. | ORDR       |       60 |
  17. | HIST       |      240 |
  18. | ITEM       |      622 |
  19. | ORDL       |      626 |
  20. | CUST       |     1040 |
  21. | STOK       |     1244 |
  22. +------------+----------+
  23. 9 rows in set (0.03 sec)